This site has a lot of info about this

http://www.contextures.com/xlDataVal02.html

Mike F
"neu2me" wrote in message
...
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?