Using Data Validation to Filter Lists
I have a list of cities orgaized alphabetically by state and then by city,
and I have just created a second list of just states. What I want to know is
if there is a way to use data-validation to create a filtered drop-down list
of cities using the state from the second list. Is this possible, and if so
how?
|