I need to merge sheet 1 on 14 closed excel workbooks that will be updated on a daily basis with new information. I tried using the RDB merge add-in, and it works pretty well. However, each sheet has the same column headers and the add-in brings the same header for each file. The add-in also brings in all of the empty spaces at the bottom of the sheet - which makes the sheet inconvenient to use.
I have a VBA module that I altered from this thread: http://www.excelforum.com/excel-prog...-new-post.html
I'm getting a "run time error 9, subscript out of range" and the code is not drawing the data into the master workbook. The debugger highlights the line "Set sourceData = sourceBook.Worksheets ("MASTER").
I will upload the master file and two examples. I hope that someone on here can give me some help with the macro. Thank you.MasterTrack1.xlsmAWhiteTracking.xlsBLoweryTracking.xls
Bookmarks