| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro question | Excel Worksheet Functions | |||
| link dynamic data to cell? | Excel Discussion (Misc queries) | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
| Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
Linear Mode
