Scenario Manager Problem

[euphrates23]

Hello,

I want to use scenario manager for my calculations but i have too many scenarios(around 1000) with 4 variables. It takes time to write scenarios manually. Besides i may change the scenarios over time.
Is there a way to upload scenarios from excel spreadsheet? Or is there another way to solve my problem?

Thanks for your repliles.

 

[Worf]

Welcome to the Board

You can use VBA to create scenarios as shown in the page below:

http://www.contextures.com/xlScenario04.html