How to Merge Documents in Excel 2007

1. Create an Excel document and then click on the 'Review' tab in the 'Changes' group. Click the option 'Share Workbook.' Click the 'Editing' tab and check the box next to the option to 'Allow changes by more than one user at the same time.'
2. Create a folder on your PC's desktop by right-clicking on your desktop. Save the original Excel document to this new folder by clicking 'Save As' and then selecting the new folder on your desktop as the destination for the Excel document. Save the copy of the Excel document you want to merge into the original document in the same folder on your PC's desktop. Make sure the two files have different file names.
3. Open the original Excel document. Click 'Tools' from the Excel window's toolbar. Select 'Compare and Merge Workbooks.' A dialog box will open and ask you to 'select the files to merge into current workbook.' Select the document you would like to merge into the original Excel document. Click 'Ok.'