Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
OK so I have a worksheet with a drop-down list that has the states of the US
listed. In the next column are 50 dependant drop down lists that have various cities listed, and depending on which state you choose, the drop down list of that state's cities shows. Is there any way I can include the option "Other" in the cities column (call it column B) without going back to my list source (my list is a named range) and typing in "other" in the lists of each of the 50 states. I am a little too lazy to do all that if I don't have to. Thank you for your time |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Data Validation - Dropdown List Not Appearing | Excel Discussion (Misc queries) | |||
Auto Update A Validation List | Excel Worksheet Functions | |||
Refresh a Validation List? | Excel Discussion (Misc queries) | |||
Validation List and VLookup are ackting strange | Excel Worksheet Functions | |||
list validation using list validation... | Excel Worksheet Functions |