ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can I read a range of scenario (input) values from a table? (https://www.excelbanter.com/excel-discussion-misc-queries/258621-can-i-read-range-scenario-input-values-table.html)

hilton

Can I read a range of scenario (input) values from a table?
 
When creating several scenarios (to ultimately get a scenario summary), it's
laborious typing in a scenario name followed by a scenario value for each
scenario. Is there any way of setting up a table of (names and) input values
and just reading them into the scenario manager?


All times are GMT +1. The time now is 11:09 PM.

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