Combining 11 "like" workbooks...

[Michelle]

I have 11 workbooks that have the same column's for A-L. Unfortunately,
since the workbooks were generated by a system - they technically have 255
columns but only the first 12 are populated. I need to (quarterly) combine
the information from row 3 to the end for all 11 into one "master"
spreadsheet. I've then created a pivot table to report off that one master.

I started writing a macro that would combine the multiple workbooks but am
concerned since the # of rows will vary from quarter to quarter. Any
recommendations on the easiest way to accomplish this?

Thanks!
Michelle

 

[Ron de Bruin]

Hi Michelle

Try this add-in or the code in the links on the bottom of the page
http://www.rondebruin.nl/merge.htm

 

[Michelle]

This looks great - thanks! I'll give it a try this morning...
Michelle