SIR HELP REQUIRED

SUDHIR VERMA

unread,

May 27, 2016, 9:07:54 AM5/27/16

to Excel VBA Lab

Dear All,

Please help as per attached file.

Thanking You

Sudhir

FORMULA REQUIRED.xlsx

Ashish Bhalara

unread,

May 28, 2016, 2:24:05 AM5/28/16

to Excel VBA Lab

Hi Sudhir,

See the attached file for solution of summarize data as per your sheet.

Click command button to run macro for require output.

You can change input range E7' and output range 'A7' in vba code as per your require.

Also see the Pivot sheet to get solution by pivot table.

Regards

Ashish Bhalara

--
www.ExcelVbaLab.com
---
You received this message because you are subscribed to the Google Groups "Excel VBA Lab - An Excel VBA Macro help Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ExcelVbaLab...@googlegroups.com.
To post to this group, send email to Excel...@googlegroups.com.
Visit this group at https://groups.google.com/group/ExcelVbaLab.
To view this discussion on the web visit https://groups.google.com/d/msgid/ExcelVbaLab/CAGpm4DSbY1yQ7Nb3RG%2B%3D9imM%3DJRyvgDCpqer3Xf4Pzt2FwpSZA%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

FORMULA REQUIRED (Solve).xlsm

Ashish Kumar

unread,

May 28, 2016, 1:18:30 PM5/28/16

to Excel VBA Lab - An Excel VBA Macro help Group

Hi Ashish Bhalara,

Good Solution...!

Regards

Ashish Kumar

sudhir verma

unread,

May 29, 2016, 2:52:42 AM5/29/16

to Excel...@googlegroups.com

It's very fine. Thanks you Sir.

From: Ashish Bhalara
Sent: ‎28-‎05-‎2016 11:54
To: Excel VBA Lab
Subject: Re: Excel VBA Macro Help Group [excelvbalab] SIR HELP REQUIRED

To view this discussion on the web visit https://groups.google.com/d/msgid/ExcelVbaLab/CAB1PCLcPrPiy4Sgs6a46Zpws8jYS-Rc1RZo3pgzK6AechL2dwg%40mail.gmail.com.

Reply all

Reply to author

Forward