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

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 100 D 150 Out put data should be Names Amount A 200 B 300 C 100 D 150

$$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 100 D 150 Out put data should be Names Amount A 200 B 300 C 100 D 150 Regards, Raghavendra --

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

create a pivot table . check the attachment. On Thu, Jul 21, 2011 at 10:49 PM, Raghavendra raghavendra@gmail.comwrote: 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