Multiple Sheets be reflected in 1 sheets as a summary (looping)

**Kooper** · 07-21-2012, 01:19 AM

Hi Everyone,

Need your help, i have attached the excel file. What i want is sheet 2,3,4,5,6,7 will be reflected in summary Sheets with loop in vb.

SumIf - in Multiple Sheets (Macro).xlsx

Thank you.

**TMS** · 07-21-2012, 01:49 AM

Why do you need VBA. If the column headings match the sheet names, you could probably do this with INDIRECT and SUMIF or SUMIFS.

Regards, TMS

**Kooper** · 07-21-2012, 02:08 AM

HI TMShucks,

My boss wanted to and dont know macro. Hope you can help me with this.

Thanks.

**TMS** · 07-21-2012, 03:21 AM

Tell you're boss there's a better way just using formulae.

See attached updated example; note that column headings and sheet names have been edited to be consistent.

Please don't ask me for a VBA solution to this.

Regards, TMS