Drop Down Lists

[David Robinson]

I need to create a drop down list, that changes selections, based on the
value of a different cell. For instance, if the value in the key cell is
Apples, then the drop down list will have different kinds of apples for the
selections. If the value in the key cell is Peaches, then the same drop down
list will now show different kinds of peaches for the selections. How is
this done?

 

[T. Valko]

See if this helps:

http://contextures.com/xlDataVal02.html

 

[JP]

FWIW, there's a pretty great explanation of cascading dropdown
validation lists in Professional Excel Development, towards the
beginning of the book. Much simpler than the other methods I've seen.


--JP