Combining 11 "like" workbooks...
 

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

Combining 11 "like" workbooks...
 

Hi Michelle

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


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Michelle" wrote in message ...
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

Combining 11 "like" workbooks...
 

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


"Ron de Bruin" wrote:

Hi Michelle

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


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Michelle" wrote in message ...
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