ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Dynamic scenarios - more than 2 variable using data tables in Exc (https://www.excelbanter.com/excel-discussion-misc-queries/103523-dynamic-scenarios-more-than-2-variable-using-data-tables-exc.html)

Varghese

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.


All times are GMT +1. The time now is 11:52 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com