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

2011-07-22 Thread Rajan_Verma
to:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: Friday, July 22, 2011 8:52 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: VBA - Remove duplicate and get sums Dear Raghvendra, Please try below code and see attached sheet Sub advancefi

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

2011-07-22 Thread Raghavendra
Hi All, Thank you all for your response. Special thanks to Noorain Ansari, who provided me what I wanted. Regards, Raghavendra On Jul 22, 8:22 am, NOORAIN ANSARI wrote: > Dear Raghvendra, > > Please try below code and see attached sheet > > Sub advancefilter_sumif() > Dim i, j As Long >

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

2011-07-21 Thread NOORAIN ANSARI
Dear Raghvendra, Please try below code and see attached sheet Sub advancefilter_sumif() Dim i, j As Long Dim abc, cba As Range Application.ScreenUpdating = False Sheet1.Range("A1:A" & Sheet1.Range("A1").End(xlDown).Row).Copy Sheet1.Range("D1").Select ActiveSheet.Paste Sheet1.Range("E1").Valu