Hi,
I have multiple Excel workbook files stored in the same folder location, each workbook file has one worksheet with a table of data. Every table in each of the workbooks is in a consistent format (so the columns are in the same order with the same data type).
Is anyone able to advise on a macro that can combine the data from all of the individual worksheet tables into one consolidated Excel file please?
I suppose the key knowledge gaps for me are ensuring the macro takes the data from all of the files in the folder, and is able to paste the data in the next blank row in the consolidated Excel workbook. This includes:
*the macro copies data from all of the files in the folder location, including any new files added since the macro was written.
*the macro does not fail if files have been removed from the folder location since the macro was written.
*the macro is able to detect the next blank row to paste the data into the consolidated Excel workbook (as the number of rows in the individual tables will change).
Details
The full path to the folder holding the workbooks in question is:
C:\Users\bkljsx\Documents\Schedule\WeeklyUpdates\WeeklyExtracts
This folder only contains Excel workbooks and no other type of file.
All the workbooks in this folder will be imported by this procedure.
There is only one sheet in each workbook (all sheets are called 'Task_Table1').
There are headings for the tables in each workbook, but I do not want these copied into the consolidated workbook.
Due to the requirement to omit the headings, the data for each table begins in cell A2.
Any guidance much appreciated!
Thanks
Jon
I have multiple Excel workbook files stored in the same folder location, each workbook file has one worksheet with a table of data. Every table in each of the workbooks is in a consistent format (so the columns are in the same order with the same data type).
Is anyone able to advise on a macro that can combine the data from all of the individual worksheet tables into one consolidated Excel file please?
I suppose the key knowledge gaps for me are ensuring the macro takes the data from all of the files in the folder, and is able to paste the data in the next blank row in the consolidated Excel workbook. This includes:
*the macro copies data from all of the files in the folder location, including any new files added since the macro was written.
*the macro does not fail if files have been removed from the folder location since the macro was written.
*the macro is able to detect the next blank row to paste the data into the consolidated Excel workbook (as the number of rows in the individual tables will change).
Details
The full path to the folder holding the workbooks in question is:
C:\Users\bkljsx\Documents\Schedule\WeeklyUpdates\WeeklyExtracts
This folder only contains Excel workbooks and no other type of file.
All the workbooks in this folder will be imported by this procedure.
There is only one sheet in each workbook (all sheets are called 'Task_Table1').
There are headings for the tables in each workbook, but I do not want these copied into the consolidated workbook.
Due to the requirement to omit the headings, the data for each table begins in cell A2.
Any guidance much appreciated!
Thanks
Jon