Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I sort excell files by date?
I prepare a A/R spread sheet each day and save them at the end of each day.
All sheets were kept in date order from 1/1 to 12/31. Now that 2009 has started the 2009 sheets are co-mingled with the 2008 rather than continuing on with the newest date at the bottom of the list How to I sort all the files so that they are in order. I have vista and 2007 excell. all the files are on an external drive that only has these spread sheets on it. There is lots of room on this drive. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I sort excell files by date?
This is a Vista issue and not an Excel issue.
You need to add the year also to your file names. Vista provides facilities for bulk rename. "finerman" wrote: I prepare a A/R spread sheet each day and save them at the end of each day. All sheets were kept in date order from 1/1 to 12/31. Now that 2009 has started the 2009 sheets are co-mingled with the 2008 rather than continuing on with the newest date at the bottom of the list How to I sort all the files so that they are in order. I have vista and 2007 excell. all the files are on an external drive that only has these spread sheets on it. There is lots of room on this drive. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I remove a sort in Excell 2003 | Excel Discussion (Misc queries) | |||
Repeat a sort in Excell 2007 | Excel Discussion (Misc queries) | |||
How to sort in excell | Excel Discussion (Misc queries) | |||
How do I sort by complete rows in excell | Excel Worksheet Functions | |||
How do I sort sheets in an excell spreadsheet? | Excel Worksheet Functions |