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
A Pivot Table is used precisely for such computations. As a thumb
rule, use Excel functions and tools where Excel can handle it
efficiently. Use VBA only if Excel cannot give desired output on its
own
On Jul 21, 10:19 pm, Raghavendra wrote:
> Hi,
>
> Can anyone let me know VBA code for the below?
