Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Greetings -
I have a pricing model in excel and am often asked to run it for multiple scenarios. For example, run it for x number of employees, with a, b, c profit margin. I would like to prompt the user for the number of scenarios that need to be run and based on their response I would like to provide them with input prompts for each scenario. For example: if the user requests two scenarios I would like them to be prompted for three different inputs two times. I would then like the two scenarios to execute and output certain calculations on a summary page. Is this asking too much from the built-in, no-programming required capabilities of Excel? Suggestions? Regards, Bryan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
excel crashing when I use scenarios tool | Excel Discussion (Misc queries) | |||
Creating a form in excel to step through scenarios | Excel Discussion (Misc queries) | |||
Comparing scenarios/forecasts in Excel | Excel Worksheet Functions | |||
Multiple vendors and scenarios - Excel | Excel Worksheet Functions | |||
Excel Scenario Manager should let me re-order scenarios (in the s. | Excel Discussion (Misc queries) |