Drop Down List is not in Descending Order
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 |
Drop Down List is not in Descending Order
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 |
All times are GMT +1. The time now is 10:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com