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
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
>
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