Scenario manager question

[geotzi]

Hi all,

I would like to use the scenario manager functionality for a business case template.

My template has multiple sheets and I use different sheet to store my inputs and outputs.

I know that the scenario manager allows me to use data from the same sheet. I would like to use data from 2 different sheets. Do you know if there is an advance option to select data from 2 different sheets?
For example: changing cells from sheetA and result cells from SheetB.

Thank you in advance.

Georgia.

 

[Hui]

Have a look at an alternative method using Data Tables
http://chandoo.org/wp/2010/05/06/data-tables-monte-carlo-simulations-in-excel-a-comprehensive-guide/
and scroll down to Multi Way tables