| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop-Down Boxes In Adjacent Columns
I have a drop-down box at the head of two columns next to each other. In the
first drop-down box, I have several States listed. Within the second drop-down box there lists many city names. I would like a set-up to where the second drop-down box will list the correct sub-set of city names that exist in the State names from the first drop-down box. How is this accomplished? Does there exist a better configuration for this? -- Daryl B. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Drop-Down Boxes In Adjacent Columns
Did you use Data|Validation for those dropdowns?
If yes... Debra Dalgleish knows how: http://contextures.com/xlDataVal02.html Daryl B. wrote: I have a drop-down box at the head of two columns next to each other. In the first drop-down box, I have several States listed. Within the second drop-down box there lists many city names. I would like a set-up to where the second drop-down box will list the correct sub-set of city names that exist in the State names from the first drop-down box. How is this accomplished? Does there exist a better configuration for this? -- Daryl B. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Matching Adjacent Columns? | Excel Worksheet Functions | |||
| How do I add input data in the input ranges in drop down boxes. | Excel Discussion (Misc queries) | |||
| Pivot Table Drop Down Boxes | Excel Discussion (Misc queries) | |||
| Text to Columns from drop down list update | Excel Discussion (Misc queries) | |||
| Has anyone created forms in Excel with drop down boxes? | Excel Worksheet Functions | |||
Linear Mode
