Drop Down List is not in Descending Order

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

Guest

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
 
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.
 
Back
Top