RE: $$Excel-Macros$$ VBA - Remove duplicate and get sums

2011-07-22 Thread Rajan_Verma
m] On Behalf Of Raghavendra Sent: Thursday, July 21, 2011 10:49 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ VBA - Remove duplicate and get sums Hi, Can anyone let me know VBA code for the below? Input Data Names Amount A 100 B 200 C 100 B 100 A 10

Re: $$Excel-Macros$$ VBA - Remove duplicate and get sums

2011-07-21 Thread ashish koul
create a pivot table . check the attachment. On Thu, Jul 21, 2011 at 10:49 PM, Raghavendra wrote: > Hi, > > Can anyone let me know VBA code for the below? > > Input Data > > Names Amount > A 100 > B 200 > C 100 > B 100 > A 100 > D 150 > > Out put data shou

$$Excel-Macros$$ VBA - Remove duplicate and get sums

2011-07-21 Thread Raghavendra
Hi, Can anyone let me know VBA code for the below? Input Data Names Amount A 100 B 200 C 100 B 100 A 100 D 150 Out put data should be Names Amount A 200 B 300 C 100 D 150 Regards, Raghavendra -- ---