Can I read a range of scenario (input) values from a table?

H

hilton

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

automating use of complicated formula 4
How to refresh a Scenario PivotTable Report? 9
faster, more effective scenario analysis? 2
What Multiple functions do I need? 2
Scenarion Manager Crashes with Pivot Table option 1
Naming the Result Cells on a Scenario Summary 0
excel crashing when I use scenarios tool 0
scenarios and pivot tables 0

Top