Copying data from 200 worksheets into 1

[HMIExcel08]

Hi All,

Is there any one who can help to think of an idea how to copy data from 200 different worksheets into 1 worksheet at once? Assume all format, column#, row# are the same.
It’s painful to do the copying and pasting 200 times each.

Thanks a lot

[oldchippy]

Hi,

Take a look at this link, it may help?

http://exceltips.vitalnews.com/Pages..._Into_One.html

[Richard Buttrey]

Hi All,

Is there any one who can help to think of an idea how to copy data from 200 different worksheets into 1 worksheet at once? Assume all format, column#, row# are the same.
It’s painful to do the copying and pasting 200 times each.

Thanks a lot

Only with VBA.

The following code will stack all the sheet data underneath each other on a sheet called "Summary"
Please note it assumes that the last cell in column A on each sheet is also in the row which contains the last cell anywhere on the sheet. i.e. if the last value in col A is in A100, there are no other columns with data below row 100. If this condition is not true, then the code will need modifying.

Please Login or Register  to view this content.

HTH

[HMIExcel08]

Thanks for the link and Code. I truly appreciate that! They will be super helpful to me