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.

Search for consolidating 2 excel sheets:

consolidating 2 excel sheets-49

Leave a Reply

Your email address will not be published. Required fields are marked *

One thought on “consolidating 2 excel sheets”

  1. Philadelphia: American Philosophical Society, 1939. First of five letters by Chamberlain mentioning Pocahontas. In this first version there is only mention that "They carryed [Smith] prisoner to Powhatan, and there beganne the English acquaintance with the savage Emperour" -- the fourth published account without mention of a rescue by Pocahontas.