MACRO TO COMBINE DATA FROM MULTIPLE EXCEL WORKSHEETS INTO ONE EXCEL FILE.

[Twenny02]

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).

Any guidance much appreciated!

Thanks

Jon

 

[SkipVought]

HI,

This will need VBA code which this forum is not designed to address. Please repost in forum707.

Please also answer the following when you repost:

1) The full path to the folder holding the workbooks in question.

2) does this folder contain ONLY Excel workbooks and no other types of files?

3) will all the workbooks in this folder be imported by this procedure?

4) is there only one sheet in each workbook?

5) are there headings for the tables in each workbook?

6) does each table begin in cell A1?

Please answer each item completely in your repost in forum707.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[Twenny02]

Hi Skip,

Thank you for your reply. I have re-posted and hopefully answered your questions.

Regards

Jon