I have set up a sheet recording an each individual’s turnover for my business ie, hours worked, etc and have set up a data validation table for drop down options of Jan, Feb, Mar,etc....
Rather than creating more work for each month on the worksheet, how can I enable the drop down to contain the data specific to each month?
Thanks Nick
Bookmarks