How to filter a 2nd list based on selection in 1st list.

I

ImOk

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unbound Combo Box Displays Fields based on a Relationship - how to? 1
Excel 2010/2007 - How much can be done with Custom Validation? 7
Custom function to find ranked subtotals 1
Question about drop down list and tables 6
List box - Find records to show in reports 8
Can I limit choices in combo box based on selection in previous bo 1
Data Validation Lists 0
Multiple options for a single record 4

Top