At the end of our semester, we will get the copies of our spreadsheet back. In Figure 3, we can see one teacher has filled in the stats for his class (Class 1) and a second teacher has filled in the data for her class (Class 2).
With the master document open, we will click the Compare and Merge button that was set up earlier. Select one or more workbooks that you want to merge and click Open. After a moment, all of the data entered in the two separate worksheets will appear in your master document (Figure 4).
Be sure to make changes in the copied sheets – if you start making changes in the master copy and later want to merge changes from the copy again you will run into some odd errors.
After you are done merging changes, you can easily disable sharing so you can focus on just keeping the master document up to date.
If you already have different documents you need to merge, the shared workbook method may not work for you. In this case, the most efficient way of merging data will be to either move worksheets between files or use copy and paste to move data between spreadsheets.