Consolidate Multiple Excel Workbooks

[ai1094]

Hi, I have 9 Excel files that follow the same structure and wanted to consolidate them all into one workbook.

The workbooks generate 2 sheets "Audit Data - Table" and "Report Data 1" as well as a site URL link on the first row.

I am only interested in consolidating the table (row 3 and everything after) from the Report Data 1 tab. See image below.

Is there a simple VBA code that will execute the above request? Thanks.

 

[alansidman]

Combine Data from Multiple Workbooks in Excel (using Power Query)

Power Query can be of great help when you want to combine data from multiple workbooks into one single worksheet. Here is a step-by-step guide on how to do this in Excel. You can combine data when it's stored in an Excel table, or even when it's not formatted as a table.

trumpexcel.com

 

[ai1094]

Combine Data from Multiple Workbooks in Excel (using Power Query)

Power Query can be of great help when you want to combine data from multiple workbooks into one single worksheet. Here is a step-by-step guide on how to do this in Excel. You can combine data when it's stored in an Excel table, or even when it's not formatted as a table.

trumpexcel.com

Thanks for this, but I am familiar with PowerQuery. I know I can use PowerQuery to accomplish this, but I would like to have a macro as well.