Hi
I have a field which contains dates which are in "mmm-yy" format. The most recent dates appear at the bottom of the list.
how can i sort the list items within the autofilter drop down to appear in descending order?
Thanks
Vincent
Hi winshent,
Highlight the data and go to the menu bar Data>Sort. there are all the options on there that you will need to sort the data
There are only 10 types of people in the world:
Those who understand binary, and those who don't!
Hi
I dont want to sort data.. i want to sort the list items in the autofilter dropdown menu in descending order..
currently they display as:
Mar-08
Apr-08
May-08
Jun-08
Jul-08
Aug-08
what i want is the dropdown list to appear like this:
Aug-08
Jul-08
Jun-08
May-08
Apr-08
Mar-08
I'm assuming you can only do this with vba
im not really aware of how to do that to be honest
There are only 10 types of people in the world:
Those who understand binary, and those who don't!
You can't, I'm afraid. There is no programmatic access to that list.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks