Hello

I am wondering if it is possible to make a dynamic table in excel where the user can put in different inputs. I am making an excel dashboard where the user is able to input information for three different scenarios. I'd like that they can input KPIs A,B,C for each different scenario in the same table to save space.


So, When they go to the drop down they can select, "Scenario 1" and the table will be blank for the user to fill in A,B,C. Then they can go back to the drop down and click "Scenario 2" and then again fill in A,B,C. All of the data could actually be stored in a different background calculation excel sheet in the same workbook.

Is something like this possible?

Any help is greatly appreciated. Thanks in advanced!