How to write macro to add summary from multiple sheet to final sheet

**Santoshmoni** · 02-01-2011, 07:58 AM

Hi,
I want to copy data from multiple sheet and paste in a summary sheet. Every days the number of increases, from where i need to copy the data. Can we write a macro such that it automatically copy the data from all the sheet for the specified field and past in summary sheet.

**royUK** · 02-01-2011, 08:02 AM

Take a look at my code here

**Santoshmoni** · 02-01-2011, 09:07 AM

Hi,
Thanks for reply...
But my requirement is bit different then the requirement u refereed.

In my workbook there are suppose 20 sheet and i want to copy the data only from 15 sheet. I have created two sheet blank to make boundary to identify the sheets need to be copied. Header is A2 to A15 and data is in B2 to B15 of each sheet. In the final sheet where i want to copy the data i have already added header as A2 to A15, now i want to just copy the data from cell B2 to B15 of all the sheet.
Please help me on this.

**royUK** · 02-01-2011, 09:29 AM

Why can't you simply adapt what I have previously posted? Set the code to exclude the 5 sheets

**Santoshmoni** · 02-03-2011, 09:08 AM

Hi,
I tried to exclude those 5 sheet and do it but i m not able to run the macro its giving the error.
I m new to write the macro, can u please help me in showing how to write code to exclude sheet.

Thanks in Advance.....