Sorting a dropdown list

[MikeFike]

Is there a way to sort a drop down list that I made? It would be even better if I could give the option to leave in the original order or sort alpha.
I googled as well as searched the forums and could not find anything.
Thanks in advance!

[mahju]

If it is a data validation list sort the source list.
To keep the original as well as sorted list numbered the original list list (A column with s. No and the other data).

Sort on S.No, No, to get the original or on data to sort alpha (select both column)

Thanks

Regards

[MarvinP]

Hi mike,

LIke this? http://www.homeandlearn.co.uk/excel2...l2007s3p1.html

If you are using the list for a dropdown validation, I'd copy the sorted list ot an out-of-the-way range and just point your validation list to it.

Maybe a better answer is that you sort it before you drop it down?

[MikeFike]

I thought I may have to sort it first...

I need to keep the original data in its order, but wanted an option on the other worksheet to sort alpha if desired. Maybe I'll just mirror the data to anther range, sort alpha, then list that.

If that is what I do, can I make it add to and resort the list range if I add a value to the original list?

EDIT:

And it seems if I mirror it to another column, I can't sort it at all. Am I doing something wrong? i.e. in L7 I put "=A7", then copied down the line.

[MikeFike]

If it is a data validation list sort the source list.
To keep the original as well as sorted list numbered the original list list (A column with s. No and the other data).

Sort on S.No, No, to get the original or on data to sort alpha (select both column)

Thanks

Regards

This sounds like it might be what I want, but I'm not quite sure at all what you mean.
Attached is an example of where I am. I can't sort the mirrored list.

[MarvinP]

Hi,

I've always copied the list to another column (I've seen some worksheets where they have a whole sheet of these sorted dropdown lists they use on other sheets) and deleted dups in that column and then sorted it.

If your list is going to grow then a short macro that does the copy and paste and delete dups and sorts may be in order.

You should also look at Named Ranges for your dropdown list. This makes the formula easier in the Validation and it can also then grow the list.

Look here for named range. http://www.contextures.com/xlDataVal01.html