In this case, you will need to combine the two spreadsheets.
Once the spreadsheets are merged, you will be able to see the information on both to make your comparison in chart or graph form. Go to the "Office" button (or "File" for earlier versions of Excel) and select "Save As," then create a back up of each spreadsheet.
This is known as merging spreadsheets, and it's a fast way to combine data without the hassles of copying, pasting and formatting.
These instructions are for Excel 2013, but the process is similar in earlier versions of the program.
By default, Excel uses the SUM function to total all the cells in the worksheets that share the same cell references (when you consolidate by position) or that use the same labels (when you consolidate by category).
You can, however, have Excel use any of other following statistical functions when doing a consolidation: AVERAGE, COUNT, COUNTA, MAX, MIN, PRODUCT, STDEV, STDEVP, VAR, or VARP.
She maintains several blogs on travel, music, food and more.
She is also a contributing writer for Suite101 and has articles published on e How and Answerbag.
From this new spreadsheet, click on the "Data" tab and click on "Consolidate." The Consolidate menu will pop up with Function and Reference fields.For Function, choose "Sum" (this is for basic consolidation, see the link in Resources for more complex tasks). Then select one of the Excel spreadsheets you want to merge.Click the upper left cell on the spreadsheet and drag to select the area to merge.The cells are now converted to numbers only without the formula.Delete the old columns and add a new header to completer the revised spreadsheet.