Excel Consolidation Question

[chijeff]

Hello from a VBA noob,

I have a workbook that contains approximately 60 sheets, one each for a different city. The data on each sheet is formatted exactly the same. I want to create a consolidated sheet that combines the data from all of the sheets. Two catches; the data is dynamic, as there are new entries being added daily. Each sheet also has summary data that resides on the same rows as the header labels and first 3 rows of data. So what I am trying to do is stipulate that whatever is copied from each row is limited to the first 12 columns so as not to copy the summary data. Also, some cells are empty. I have attached a sample with similar formatting. Any help would be greatly appreciated. Thanks!

[patel45]

attach a sample file adding the desired consolidated sheet

[JBeaucaire]

'MANY SHEETS TO ONE SHEET
Here's a macro for merging data from multiple sheets into a "consolidation" sheet where the source sheets are the same layout.

Sheets to One Sheet - Part 1

There's a sample file there, too, to make it easy to try it out.


The key edits I would suggest are:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.