Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I attach data to a validation drop-down box?
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! |
#2
|
|||
|
|||
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! |
#3
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation | Excel Worksheet Functions | |||
Automatic Data Validation drop down creation | Excel Discussion (Misc queries) | |||
Data Validation - Drop down lists - if then? | Excel Discussion (Misc queries) | |||
Data Validation | Excel Discussion (Misc queries) | |||
Effect of Conditional Formatting, Data Validation | Excel Discussion (Misc queries) |