View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Varghese Varghese is offline
external usenet poster
 
Posts: 1
Default 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.