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.