Consolidating 2 excel sheets
How do you merge multiple Excel worksheets into one master worksheet, The file I’m working with, which you can download here or at the end of this post, is for a fake used car dealership that sells the Honda Accord, Honda Civic, Toyota Corolla, Toyota Matrix and Toyota Camry.
Excel makes it easy to combine data from difference sources into one master spreadsheet.
Make sure to select extra rows after the data to make room for the data you're adding.
You will see the Reference field populate with the spreadsheet information (it will look something like this: '[DS Excel Book 1.xlsx]Sheet1'! In the Consolidate menu, under Use Labels, click to select "Top Row" or "Left Column," or both depending on where your labels are.
First, open Excel and open both of the files you're looking to merge. Now open a new spreadsheet, which will be the destination for your merged data.
From this new spreadsheet, click on the "Data" tab and click on "Consolidate." The Consolidate menu will pop up with Function and Reference fields.