| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to filter a 2nd list based on selection in 1st list.
I have two lists States and Counties that I have created with
Data/Validation. I would like when the user selects a State to only show in the Counties lists the counties for that state. Does anyone have a suggestion or sample code how to do this? Any help is appreciated. States List has 4 items NY NJ PA CT Counties List has counties that start with the state initials: NY-Suffolk NY-Nassau NJ-Bergen NJ-Essex .... .... |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to filter a 2nd list based on selection in 1st list.
See
http://www.contextures.com/xlDataVal02.html In article . com, "ImOk" wrote: I have two lists States and Counties that I have created with Data/Validation. I would like when the user selects a State to only show in the Counties lists the counties for that state. Does anyone have a suggestion or sample code how to do this? Any help is appreciated. States List has 4 items NY NJ PA CT Counties List has counties that start with the state initials: NY-Suffolk NY-Nassau NJ-Bergen NJ-Essex ... ... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to I filter one list based on another list? | Excel Discussion (Misc queries) | |||
| Filter multiple workbooks from drop down list selection | Excel Worksheet Functions | |||
| Filter the results of a list based on a previous vlookup against the same list | Excel Worksheet Functions | |||
| validation list - filter based on selection | Excel Worksheet Functions | |||
| limit cell list selection based on the selection of another list | Excel Worksheet Functions | |||
Linear Mode
