When we calculate data in multiple Excel worksheets, we often need to merge the data before we can start the calculation. Only in this way can the calculation efficiency be improved faster. Here are a few tips for you. I hope they will be helpful to you.
Excel
1. Consolidate calculations based on position or classification
You can only change consolidations if you have not previously selected the Create link to source data check box in the Consolidation dialog box. If the check box is selected, click Close and recreate the consolidation.
a. Click the upper left cell of the merged data.
b. On the Data tab, in the Data Tools group, click Consolidate.
c. Please perform one or more of the following operations:
2. Add the source area to start the merge calculation
The new source range must have data in the same location or have column labels that match those in other ranges in the consolidation.
1. If the worksheet is in another workbook, click "Browse" to locate the file, and then click "OK" to close the "Browse" dialog box. Enter the file path followed by an exclamation point in the Reference box.
2. Type the name you want for the zone, and then click Add.
3. Adjust the size or shape of the source area
1. Under "All Reference Locations", click the source area you want to change.
2. In the "Reference" box, edit the selected reference.
3. Click "Add".
4. Delete the source area from the combined calculation
1. In "All Reference Locations", click the source area you want to delete.
2. Click "Delete".
3. Automatically update combined calculations.
The above points are some operation tips for merging multiple Excel work documents. I hope they will be of some help to you.
