I've created different months (Month 1 - 36) in a dropdown box. Used the horizontal "Month 1, Month 2, etc" columnn headings as source to create the dropdown box.
I've calculated a sales projection based on input factors.
I want the sales projection to start in the month that I specify in the dropdown box:
Example:
Sales projection: 35,37,39,45,51,48,78
Start sales projection figures in selected month from dropdown box "Month 3". The sales projection figures should now start in column "Month 3"
If I change the dropdown box reference to "Month 4", I want the sales projections then to start in the "Month 4" column
Bookmarks