What I would like to do is have a drop-down box where I select an item and
have it populate the next drop-down box with data that relates to the former
box.

Example:
First drop-down has the entries breakfast,lunch,dinner,snack
2nd drop-down list would populate depending on your first choice: for
breakfast it would offer: cereal,ham-n-eggs,yogurt,fruit
3rd would relate if you chose fruit: banana,apple,orange,mango
so on and so forth.

Let me know if there is a way to do this.

Thanx!

See this link:

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

Hope this helps
Rowan

Dustmote wrote:
What I would like to do is have a drop-down box where I select an item and
have it populate the next drop-down box with data that relates to the former
box.

Example:
First drop-down has the entries breakfast,lunch,dinner,snack
2nd drop-down list would populate depending on your first choice: for
breakfast it would offer: cereal,ham-n-eggs,yogurt,fruit
3rd would relate if you chose fruit: banana,apple,orange,mango
so on and so forth.

Let me know if there is a way to do this.

Thanx!

Rowan,

Correct website, incorrect page for what I wanted. Now that I know the
correct name for what I want to do 'Dependant Drop-down list'. But you DID
direct me to where I needed to be.

Thank You!

"Rowan" wrote:

See this link:

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

Hope this helps
Rowan

Dustmote wrote:
What I would like to do is have a drop-down box where I select an item and
have it populate the next drop-down box with data that relates to the former
box.

Example:
First drop-down has the entries breakfast,lunch,dinner,snack
2nd drop-down list would populate depending on your first choice: for
breakfast it would offer: cereal,ham-n-eggs,yogurt,fruit
3rd would relate if you chose fruit: banana,apple,orange,mango
so on and so forth.

Let me know if there is a way to do this.

Thanx!