I'm creating an excel sheet to forecast the number of required employees based on matrices that I set up. I would like to add a drop down on the forecast detail tab, that has all the job codes on the other tabs, and when a job code is selected from the drop down, the forecast is calculated based on the sales matrix in its associated tab.
Solved by B. B. in 22 mins