Linking drop down boxes

[zaika]

I'm attempting to create a form where I have a number of columns of dro
down boxes of lists.
I have one column where I have created drop down boxes linked to a mai
list. Each item of the main list has a separate "daughter" list.
Each "daughter" list is different.
In the form, I want the adjacent column related to the main list dro
down choices to contain a drop down list of the relevant "daughter
information only; in other words, when one item from the main list dro
down box is selected, the choices in the adjacent drop down list mus
relate to the selected main list item only.

Can anyone please tell me how this may be achieved?
(currently, I'm using Excel 2000, but will also use Excel 2003, in cas
this is relevant.

 

[Dave Peterson]

Debra Dalgleish has some notes how to use Data|Validation and dependent lists
at:

http://www.contextures.com/xlDataVal02.html

Maybe you can use some of her techniques.

 

[Gord Dibben]

Visit Debra Dalgleish's site to get the basics of using Data Validation
drop-down lists and how to create "dependent" lists.

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

1. The basics

2. Create dependent lists.

Gord Dibben Excel MVP