Macro Sheets Only
Equivalent to choosing the Scenarios command from the Tools menu and then selecting Merge. This function merges scenarios from other sheets onto the active sheet. A scenario is a set of values to be used as input for a model on your worksheet.
Syntax
SCENARIO.MERGE(source_file)
SCENARIO.MERGE?(source_file)
Source_file is the name of the book and sheet from which you want to merge scenarios onto the active sheet.
Related Functions
SCENARIO.GET Returns the specified information about the scenarios defined on your worksheet
List of Customizing Functions