I have a little more than 100 files coming in every month in which I have to collect the data and place it it one master file.
I came across Chandoo's tutorial link:
http://chandoo.org/wp/2012/04/09/consolidate-data-from-different-excel-files-vba/
Everything works fine except that I wanted the additional function of being able to copy the dynamic range of each Excel monthly report.
I have attached 3 files.
vba-macro-to-copy file - This is the file chandoo made to consolidate the data into one sheet.
A.xlsx & B.xlsx - These are just 2 examples of the reports that I receive every month.
I think my problem is that I cannot determine on the scope of using the ActiveWorkbook to be able to use the LastRowInOneColumn function.
Can someone help in how I can use that function for the dynamic ranges of the individual Excel files?
Thank you
I came across Chandoo's tutorial link:
http://chandoo.org/wp/2012/04/09/consolidate-data-from-different-excel-files-vba/
Everything works fine except that I wanted the additional function of being able to copy the dynamic range of each Excel monthly report.
I have attached 3 files.
vba-macro-to-copy file - This is the file chandoo made to consolidate the data into one sheet.
A.xlsx & B.xlsx - These are just 2 examples of the reports that I receive every month.
I think my problem is that I cannot determine on the scope of using the ActiveWorkbook to be able to use the LastRowInOneColumn function.
Can someone help in how I can use that function for the dynamic ranges of the individual Excel files?
Thank you