How to sort a drop-down list?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a worksheet (wsA) acting as a database with columns ID, Name and Amount.

I defined a name for each of these of columns.

On the other worksheet (wsB), I made a drop-down list for each of these
names using Data->Validation.

However, the items in the drop-down list is not sorted because my data in
wsA is not sorted and I don't want to sort it manually everytime I add a
record to wsA. I want it to be sorted because this is easier for user to
search for a particular record.

Is there a way to sort the items in the drop-down lists without using Macro?
If no, marco is fine too.

Thanks.
 
Hi Daniel,
You would need a macro, but you could use a low maintenance macro
that sorts the list upon deactivation of the worksheet that the defined name
actually refers to. I would not suggest sorting upon change as the flipping
around of cells would confuse you.
http://www.mvps.org/dmcritchie/excel/event.htm

No specific macro for Private Sub Worksheet_Deactivate()
but you can use the example in
http://www.mvps.org/dmcritchie/excel/sorting.htm#activate
to give you an idea, or perhaps it as is..
 
Back
Top