Morning guys,

Need some help please. I am building a Performance Indicator Dashboard for my employer and trying to add some efficiencies into it. One area i am struggling with is regarding my drop downs. I want to set it up so that i have 2 drop down boxes, the first with the options for Quarter1,2,3 and 4 and the second with the 12 months of the year.

What i want to happen from this is that if i select Quarter 1 for example ith will give me options in the 2nd drop down box of Jan, Feb or March, if i select Quarter 2 then i get options of Apr, May, June ETC. If there is anyone out there who could point me in the right direction i would be really greatful.

Kind regards

John