Dynamic scenarios - more than 2 variable using data tables in Exc
Is it possible to create a 'dynamic' scenario analyser in Excel using/linking
one/multi variable data table (Data -- Tables)? The problem with Tools --
Scenarios is that it is not dynamic and flexible as 'data tables', even
though we could feed in more variables. The Tools -- Solver gives us only
one scenario at a time. Please help.
|