Drop drow box - Help!

[Crystal]

I am trying to create a drop down box that feeds from another drop dow
box ... is this possible? For example, if I select "Yellow" in on
drop down box, I want the second drop down box to only contain certai
values such as "Sun" and "Flowers". If "Blue" was selected from th
first box, the second drop down box would only allow "Eyes" and "Moon
as possible selections. Can anyone help me?

Thanks

 

[Bob Phillips]

Crystal,

Mail me direct and I will send you a workbook example of this that can
easily be used for your data.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Crystal]

thanks bob, but no email was listed for you.

 

[Bob Phillips]

bob . phillips @ tiscali . co . uk

remove all the spaces

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Gord Dibben]

Crystal

See Debra Dalgleish's site for dependent lists using Data Validation
drop-downs

http://www.contextures.on.ca/xlDataVal02.html

Gord Dibben Excel MVP