Start Consolidating two excel files

Consolidating two excel files

Today we will tackle a problem that many Excel users are struggling with daily - how to merge multiple Excel sheets into one without copying and pasting.

For the wizard to identify the columns correctly, make sure you have selected the option My tables have headers.

As the result, your Excel worksheets will be merged as demonstrated in the following screenshot. Merge certain columns from multiple sheets If you have really large sheets with tons of different columns, you may want to merge only the most important ones to a summary table.

As the result, the Consolidate Worksheets Wizard will find identically named columns in other sheets that you've selected and copy data only from those columns.

These examples have demonstrated only 2 options included in the Consolidate Worksheets Wizard, but there is much more to it.

At that, it's rather complex and requires a long learning curve.

The following tutorial explains the common uses in detail: Combine data from multiple data sources (Power Query).

But if you are to merge tens of sheets, errors with manual copying/pasting are inevitable.

In this case, you may want to employ one of the following techniques to automate the merge.

And if you find the add-in useful, we will gladly offer you the 15% off coupon code that we've created especially for our blog readers: .

If you are a power Excel user and feel comfortable with macros and VBA, you can combine multiple Excel sheets into one by using some VBA script, for example this one.

And the 15% off coupon code I've provided for the Consolidate Worksheets Wizard works for this add-in as well :) This is how you consolidate data and merge sheets in Excel.