How it works
This function allows users to combine tables within multiple sheets in the same document into one table. This requires that the headers are the same and that they are all in the same row.
How to use it:
Step 1
In the Cleaning and Structuring group of The Audit Toolbar, click on Combine and navigate to Active Workbook.
A new pop-up window will appear.
Step 2
Select all the sheets to be combined or select Select all.
Step 3
If the heading starts in the first row, click continue.
If not, then untick the Start at First Row tickbox. In the Select Header Row box, select the header row, then click continue.
Note: all the sheets should have their header rows in the same row for this function to work.
Step 4
Upon execution of the function, a new sheet with all the information from the selected sheets will be populated.
