Macro to save inputs and link to a dynamic drop down list

[tml2424]

I have a file where a user can select from a drop down list and then enter metrics for that department. Then when the user selects a different department from the list, the metrics to the right would auto populate based on what was last input for that department. For example, if a user has "Department 1" selected, they could input 20 into metric 1. Then a user would select "Department 2" and enter 100. Then the user could go back to "Department 1" and the 20 would show. Does that make sense?

[mehmetcik]

Please discuss the years columns and what happens when time passes. Are More yeas shown? Are last 4 years shown. Are Years older than 4 deleted or kept.

[tml2424]

When time passes, the forecast inputs are overwritten with Actuals. The years will only show historical actuals for 2020. There wouldn't be years older than 1 year. Does that answer your questions?