sharc316
03-14-2017, 05:47 PM
Hi,
I've been searching literally all day for a solution to this and cannot find anything that works. Everything I've tried gives me errors. Please see below:
I have multiple excel/.xls files in a folder and each workbook has multiple sheets. Each worksheet has consistent data structure across each of the files, however each file might not have the same number of worksheets. Meaning that if there is no data for a particular category is a certain period then the worksheet will not be created. I would like to consolidate all the data into one file.
- The master file should have the first row as data labels in each of the work sheets
- The worksheets should be matched by name, if possible, and consolidated
- The row range is dynamic and cannot be defined. Need some sort of procedure to check if there is no more data
Any help with this would be greatly appreciated.
I've been searching literally all day for a solution to this and cannot find anything that works. Everything I've tried gives me errors. Please see below:
I have multiple excel/.xls files in a folder and each workbook has multiple sheets. Each worksheet has consistent data structure across each of the files, however each file might not have the same number of worksheets. Meaning that if there is no data for a particular category is a certain period then the worksheet will not be created. I would like to consolidate all the data into one file.
- The master file should have the first row as data labels in each of the work sheets
- The worksheets should be matched by name, if possible, and consolidated
- The row range is dynamic and cannot be defined. Need some sort of procedure to check if there is no more data
Any help with this would be greatly appreciated.