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...g.htm#activate
to give you an idea, or perhaps it as is..

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Daniel" wrote in message ...
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.