Video:Merge Spreadsheets in Excelwith Don Schechter
You can easily combine and organize data from different spreadsheets into one Excel spreadsheet. Learn how to merge spreadsheets and automatically update them when you change the individual files.See Transcript
Transcript:Merge Spreadsheets in ExcelHi! I'm Don Schechter for About.com Computing. Today I'll show you how to merge spreadsheets in Microsoft Excel.
Open Excel Sheets to MergeFirst open Excel. I'll open three spreadsheets that have the same headers. I want to put all of this information in the same spreadsheet. Create a new spreadsheet by clicking the 'new' icon at the top.
Merge the Separate SpreadsheetsNow go up to 'data' and choose 'consolidate.' A window will open. Choose 'sum' as the function under the drop down menu. Now for the references, click the 'browse' button. Go up to window and choose your first spreadsheet. Click and drag an area with your information in it. Leave lots of room at the bottom. Now click the icon in the consolidation window and then click 'add.' Do the same with your other spreadsheets.
Automatically Update the Merge SpreadsheetMy spreadsheets all have the same headers, so I'll check off 'Use Labels In Top Row and Left Column.' If you plan on changing your data in their individual files, you can check this box so the merged spreadsheet will automatically update when you open it again. Click 'ok.'
Now you can see I have all my information in one spreadsheet. Thanks for watching. To learn more, visit computing.about.com.