Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can you make a drop down list in a drop down list? | Excel Discussion (Misc queries) | |||
circular drop down list on different pages | Excel Worksheet Functions | |||
How do I make other cells dependent on my drop down list? | Excel Discussion (Misc queries) | |||
Data Validation using List (But needs unique list in drop down lis | New Users to Excel | |||
How do you create a drop down list? | Excel Discussion (Misc queries) |