Make Data validation List Alphabetical??

[Guest]

how can i make my data validation list drop down, display my city names in
alphabetical order?

 

[Frank Kabel]

Hi
you need a sorted source list )

--
Regards
Frank Kabel
Frankfurt, Germany

"Slumbering Gorilla" <[email protected]>
schrieb im Newsbeitrag
news:[email protected]...

 

[Guest]

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]

Hi
is this a long or short list. For the latter you could use a helper
column with formulas which sort your original data

--
Regards
Frank Kabel
Frankfurt, Germany

"Slumbering Gorilla" <[email protected]>
schrieb im Newsbeitrag

 

[Guest]

so far the list is 90 and growing. 90x90 exactly.
Its a mileage table. with the headers being names of cities. and im useing
the headers for the list. so in one cell A3 i have the "from city" which are
the row headers, and in b3 "to city" which are the column headers.then in c3
it gives me the intersect (just to give you an idea what im useing it for).
the formula i have in it is
=evalcell(A3&" "&B3)
with a macro enabled

i was trying different thing to sort. but they kept conlflicting with the
above formula. just to let you know im pretty new at this.

but i was about to retype everything in from the handwritten originals. but
those arent in alphabetial order either. so its couple weeks of work since i
cant work on this exclusively.

but the main goal for this is to simplify and speed the city entries in A3
and B3. and typing it in is not too good since there are a lot of "_" and
misstypes are all too common around here.

 

[Frank Kabel]

Hi
if you like send me an example sheet and I'll set something up for you
email: frank[dot]kabel[at]freenet[dot]de

--
Regards
Frank Kabel
Frankfurt, Germany

"Slumbering Gorilla" <[email protected]>
schrieb im Newsbeitrag

 

[Guest]

Thanks Frank. made my life easier.

Hi
if you like send me an example sheet and I'll set something up for you
email: frank[dot]kabel[at]freenet[dot]de

--
Regards
Frank Kabel
Frankfurt, Germany

"Slumbering Gorilla" <[email protected]>
schrieb im Newsbeitrag

so far the list is 90 and growing. 90x90 exactly.
Its a mileage table. with the headers being names of cities. and im useing
the headers for the list. so in one cell A3 i have the "from city" which are
the row headers, and in b3 "to city" which are the column headers.then in c3
it gives me the intersect (just to give you an idea what im useing it for).
the formula i have in it is
=evalcell(A3&" "&B3)
with a macro enabled

i was trying different thing to sort. but they kept conlflicting with the
above formula. just to let you know im pretty new at this.

but i was about to retype everything in from the handwritten originals. but
those arent in alphabetial order either. so its couple weeks of work since i
cant work on this exclusively.

but the main goal for this is to simplify and speed the city entries in A3
and B3. and typing it in is not too good since there are a lot of "_" and
misstypes are all too common around here.