The command Data | group Analyze | Scenario manager can also be used to merge scenarios that have been defined on other worksheets (or even other workbooks) into the current worksheet.
Note: When using this function, make sure that all workbooks whose scenarios are to be merged have exactly the same layout and use the same changing cells in their scenarios.
To merge scenarios, proceed as follows:
| 1. | Open the workbooks that contain the scenarios to be merged. |
| 2. | Switch to the workbook and worksheet into which you want to merge the scenarios. |
| 3. | Choose the ribbon command Data | group Analyze | Scenario manager  . |
| 4. | Click Merge in the dialog box. |
| 5. | Select the workbook and worksheet that contains the scenario(s) to be merged. |
| 7. | Repeat the steps 4. through 6. for all further scenarios that you want to merge. |
The selected scenarios are now available in the current worksheet.