• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Merging Scenarios

The scenarios you create are stored with each worksheet in a workbook. If you have similar models in different sheets (for example, budget models for different divisions), you can create separate scenarios for each sheet and then merge them later. Here are the steps to follow:

1.
Activate the worksheet in which you want to store the merged scenarios.

2.
Choose Tools, Scenarios to display the Scenario Manager.

3.
Click Merge. Excel displays the Merge Scenarios dialog box, shown in Figure 14.26.

Figure 14.26. Use the Merge Scenarios dialog box to select the scenarios you want to merge.


4.
Use the Book drop-down list to click the workbook that contains the scenario sheet.

5.
Use the Sheet list to click the worksheet that contains the scenario.

6.
Click OK to return to the Scenario Manager.

7.
Click Close to return to the worksheet.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint