Drop down lists

[Maureen Sepulveda]

Hi!

I need help creating a drop down list. Not just a basic drop down, but three different ones that are dependent of each other. For example, first drop down you choose the year, the second drop down you choose [Quarter, Month, Week], the third drop down is dependent on the the two previous selections. Does this make sense? I've attached a dummy worksheet to show what I need.

Thank you in advance!!!

 

[NARAYANK991]

Hi Maureen ,

See this file.

Narayan

 

[Eric M]

I think Chandoo's recent post may be helpful.... http://chandoo.org/wp/2014/02/13/dy...(Chandoo.org+-+Learn+Excel+&+Charting+Online)

Wow, that's a long URL.....

 

[Maureen Sepulveda]

Hi Maureen ,

See this file.

Narayan

This works great! Thank you!