How to Merge 2 Excel Workbooks in Excel 2007

Share the Workbook
1. Launch Microsoft Excel on your computer. Click 'File' and then 'Open' on the ribbon bar. Navigate to the file to share, highlight it and click the 'Open' button.
2. Click 'Tools' and then 'Share Workbook.' Click the 'Editing' tab and then enable the 'Allow Changes by more than one user at the same time' option.
3. Click the 'Advanced' tab and then click 'Track changes.' Click the 'Keep change history for:' option. In the 'Days' text box, enter a number of days for the estimated time needed for others in the group to edit the file and review changes. Click the 'OK' button.
4. Click 'File' then 'Save' on the ribbon bar to save the workbook.
Merge the Shared Workbooks
5. Launch Excel and open the original version of the shared workbook -- not the ones that users edited.
6. Click 'Tools' and then 'Merge Workbooks' on the ribbon bar. In the pop-up box, click and select one of the distributed copies of the workbook. Click the 'OK' button.
7. Merge other distributed workbooks as needed using the 'Merge Workbook' function.