SCENARIO.MERGE

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