Hi I am doing a stock valuation and I have three scenarios, one with bullish outlook, one with bearish outlook and one with normal outlook.
In each outlook scenario I will change several cells such as the revenue growth projection, the estimated profit margin, etc.
I would like to have a drop-down list where I can simply select which outlook I want and the sheet will automatically display my stock valuation result.
I have already created the scenario manager using Data>What-If Analysis>Scenario Manager and I know how to make the drop down list using Data>Data Validation>List, but I don't know how to link the drop down list with the scenario manager.
I have attached the stock valuation file. Any help will be very much appreciated. Thank you so much!
Bookmarks