Drop Down Lists
 

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?

Drop Down Lists
 

See if this helps:

http://contextures.com/xlDataVal02.html

--
Biff
Microsoft Excel MVP


"David Robinson" wrote in message
...
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?

Drop Down Lists
 

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

On Apr 15, 10:09*pm, "T. Valko" wrote:
See if this helps:

http://contextures.com/xlDataVal02.html

--
Biff
Microsoft Excel MVP

"David Robinson" wrote in message