Show All

Merge scenarios from another worksheet

It is easier to merge scenarios when all what-if models on the worksheets are identical. All changing cells on the source worksheet must refer to the corresponding changing cells on the active worksheet. Microsoft Excel copies all scenarios on the source sheet to the active worksheet.

1. Open all of the workbooks that contain the scenarios you want to merge.
2. Switch to the worksheet where you want to merge the scenarios.
3. On the Tools menu, click Scenarios.
4. Click Merge.
5. In the Book box, click a workbook name.
6. In the Sheet box, click the name of a worksheet that contains the scenarios you want to merge, and then click OK.
7. Repeat this process if you want to merge scenarios from more worksheets.