Drop Down List is not in Descending Order

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
 
D

Dave Peterson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filtered drop down list 2
pivot table - drop down filter box has 10% of items out of order 2
How to Update drop-down list? 5
Cannot See Sort Ascending/Descding option in drop down filter 1
limit autofilter drop down menu entries 1
Seeding in Drop Down List 3
how do generate a drop down list with no blanks 2
ADD ITEM TO A DROP DOWN LIST? 4

Top