How to merge Scenarios in EXCEL 2010
How to merge Scenarios in EXCEL 2010 Prior to starting about our title, lets have a quick recap of "What Scenario is". Scenario can be defined as " Set of combination of values, that can be created for any fixed range of cells and may be used as and when required" . Excel also offers, Scenario Summary to get values of all combinations at once, so that we may look at all available combination at a glance. Merge scenarios Select the worksheet in which to store the merged scenarios results. On the Data tab, in the Data Tools group, click What-If Analysis , and then click Scenario Manager . Click Merge . In the Merge Scenarios dialog box, click the arrow next to Book and select a workbook that contains scenarios that you want to merge in your results. In the Sheet box, click the name of the worksheet that contains scenarios that you want to merge. Click OK to merge the scenarios from the selected workshee...