Excel 2010 : Combine Multiple Workbooks into One Master Workbook

[tehjagjr]

Hi guys, I'm trying to merge multiple workbooks ( Around 50-60 ) into one master workbook.

The workbooks are all the same but filled with different data with different end points ie: Start Cell range A2:M2 with the end cell range being anywhere else but along the lines of A:M , The workbooks should be cleared at the end of the macro except the master workbook.

Any help would be much appreciated as i'm merging them all by hand and it takes me ages.

Thanks

[dogberry]

http://www.extendoffice.com/document...workbooks.html

Hi

Have a look at the second part of the above link first part deals with VBA second part explains in detail how to do it.


Chris

[AB33]

Do you mean multiple worksheets(Tabs)? as multiple workbooks requires accessing your folder. Please attach a sample.