Scenario Management with VBA

Creating complex scenarios in a model can be difficult. The typical way is to save 70 different workbooks containing different assumptions and hope you remember what they are. Here I have created a scenario management tool using VBA that allows the user to save up to 5 different scenarios inside one model and see the impacts visually on one dashboard.
The video below walks through a model that creates a worst-case scenario and compares two other budget scenarios. As you save each scenario, the user can name and type descriptions of the assumptions. The original scenario inputs can be loaded with the click of a button.