Re: $$Excel-Macros$$ Re: Extract duplicate data and run calculation- macro request

2014-06-27 Thread Pramod Singh
Hi Missy, PFA It's My Pleasure to help your. And do not say thanks yaar Be happy. Pramod On Fri, Jun 27, 2014 at 4:05 PM, Missy786 wrote: > Dear Pramod, > > Thank you for your reply back. > > I am writing to request, if it is possible to update the code, so it also > extracts the n

Re: $$Excel-Macros$$ Re: Extract duplicate data and run calculation- macro request

2014-06-27 Thread Missy786
Dear Pramod, Thank you for your reply back. I am writing to request, if it is possible to update the code, so it also extracts the name's prices and type, if its not too much trouble. Please see the updated new attachment for further details. Thank you so much for all your help and time into

Re: $$Excel-Macros$$ Re: Extract duplicate data and run calculation- macro request

2014-06-26 Thread Pramod Singh
; > > > > *“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > ----------------- > > *From:* Missy

$$Excel-Macros$$ Re: Extract duplicate data and run calculation- macro request

2014-06-26 Thread Missy786
Dear Pramod, Than you very much for your solution. I really appreciate your time and help into this. I have one small question, which is I would like to change the range of where the data is pasted in sheet2, however I am unable to access the code as it s password protected. is it possible

Re: $$Excel-Macros$$ Re: Extract duplicate data and run calculation- macro request

2014-06-26 Thread Pramod Singh
Hi Missy, Please file the attached file which you have required. Regards Pramod VBA Delevoper . On Thu, Jun 26, 2014 at 7:10 PM, Paul Schreiner wrote: > Would you please send me a file with a larger sample? > schreiner_p...@att.net > I just need the name, price and date columns, you can clear

$$Excel-Macros$$ Re: Extract duplicate data and run calculation- macro request

2014-06-26 Thread Paul Schreiner
Would you please send me a file with a larger sample? schreiner_p...@att.net I just need the name, price and date columns, you can clear the rest. I'd LIKE the full 50,000+ lines. There's a couple of approaches I'd like to try, but the time to process a large number may be significant. also,

Re: $$Excel-Macros$$ Re: Extract duplicate data and run calculation- macro request

2014-06-26 Thread Pramod Singh
Hi, You told that you have 5 row data. if macro will run there so time will be take a lot. Regards Pramod On Thu, Jun 26, 2014 at 3:09 PM, Missy786 wrote: > Thank you for your solution and help. I am ideally looking for a macro, >> which can extract the names and prices, hence I would l

$$Excel-Macros$$ Re: Extract duplicate data and run calculation- macro request

2014-06-26 Thread Missy786
> > Thank you for your solution and help. I am ideally looking for a macro, > which can extract the names and prices, hence I would like to be able, to > add more features to the code and it would update quickly when the input > data changes in the sheet1. > the desired output is -- extract