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
Bookmarks