How to?

[frus88]

Hi sorry for the non descriptive subject line.


I have an excel sheet with lots of data and drop down lists. I would like to make it so that when I select a dropdown list in one cell, in the next cell it will automatically show the correct related drop down list.


Does this make sense, they will be quite a few different choices depending on what has been selected.


If someone could point me in the right direction I'd be very grateful.


Ally

 

[VoG]

See if this helps http://www.contextures.com/xlDataVal02.html

 

[frus88]

That's just what I was looking for - thank you!