|
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
...
...
|