Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I create a form with drop downs that narrows choices?
Hi.
Imagine I have 10 brands, 5 sizes, 5 states, etc. Brand 1 has size 1 and 3, and is in states 3,4 and 5 Brand 1 has size 4 in state 1 Brand 2 has size 3, and is in states 1,2 and 3 I would like to set up a form or template with drop downs that enable you to choose a number of selections (brand, size, state, etc.), and return a specific value in each column. So, if the columns are brand, size, state, you choose brand 1. The only options in the size column/drop-down menu would be 1, 3, and 4. If you choose 4, the only choice is state 1. If you choose 1 or 3, you have the choice of 3, 4 or 5. Any ideas? |
#2
|
|||
|
|||
You may want to take a look at how Debra Dalgleish does it with Data|Validation.
http://www.contextures.com/xlDataVal02.html Joeglobal wrote: Hi. Imagine I have 10 brands, 5 sizes, 5 states, etc. Brand 1 has size 1 and 3, and is in states 3,4 and 5 Brand 1 has size 4 in state 1 Brand 2 has size 3, and is in states 1,2 and 3 I would like to set up a form or template with drop downs that enable you to choose a number of selections (brand, size, state, etc.), and return a specific value in each column. So, if the columns are brand, size, state, you choose brand 1. The only options in the size column/drop-down menu would be 1, 3, and 4. If you choose 4, the only choice is state 1. If you choose 1 or 3, you have the choice of 3, 4 or 5. Any ideas? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create drop down form fields in Excel? | Excel Discussion (Misc queries) | |||
How do I create a form that can be filled in on the computer | Excel Discussion (Misc queries) | |||
How to create a drop down menu which referencing a different workb | Excel Discussion (Misc queries) | |||
How do you create a drop down list? | Excel Discussion (Misc queries) | |||
how do I create a drop down menu in Excell? | Excel Worksheet Functions |