Drop down boxes with months shown that change all the data

[nick-w]

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

[Miroslav R.]

Hi there,
pls 'Go Advanced' and attach sample workbook.

Regards

M

[nick-w]

To be able to post Visitor messages your post count must be 5 or greater. You currently have 1 posts.