unfortunatly my sourcelist is part of a table. and reorginizing it will take
days. but if it comes down to it i will have to do that. but i just added a
data validation list, and not having it in alphabetical order makes it pretty
much useless due to the number of names in it. so i was trying to avoid
retypeing the table.

"Frank Kabel" wrote:

Hi
you need a sorted source list :-))

--
Regards
Frank Kabel
Frankfurt, Germany

"Slumbering Gorilla"
schrieb im Newsbeitrag
...
how can i make my data validation list drop down, display my city
names in
alphabetical order?