View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
neu2me neu2me is offline
external usenet poster
 
Posts: 7
Default 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?