You could record a macro when you sort the data the way you want--then just
rerun that macro when you want.

Debra Dalgleish has some sample code at:
http://contextures.com/xlSort02.html

That allows you to sort by clicking on a rectangle in the header cell.

You may like it.

John wrote:

When new items are added to my data table, they appear at the bottom of the
drop down list. Is there a way to have excel automatically re-sort such that
the drop down list is in the proper sort order...numeric then alpha

--

Dave Peterson