Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
problems with dates
I want to change the dates on my spread sheet so that the most current date
always is on the top of my list. Is this possible? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
problems with dates
Sort it descending, DataSort
-- HTH Bob Phillips (replace xxxx in email address with googlemail if mailing direct) "Nikki Q" wrote in message ... I want to change the dates on my spread sheet so that the most current date always is on the top of my list. Is this possible? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
problems with dates
Sort the date column into ascending order? -- mrice Research Scientist with many years of spreadsheet development experience ------------------------------------------------------------------------ mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931 View this thread: http://www.excelforum.com/showthread...hreadid=545216 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
problems with dates
is there anyway to have it automaticaly do it or will I have to continue to
do it everytime i add more info to my spreadsheet? "Bob Phillips" wrote: Sort it descending, DataSort -- HTH Bob Phillips (replace xxxx in email address with googlemail if mailing direct) "Nikki Q" wrote in message ... I want to change the dates on my spread sheet so that the most current date always is on the top of my list. Is this possible? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
problems with dates
You could do it by event code
'----------------------------------------------------------------- Private Sub Worksheet_Change(ByVal Target As Range) '----------------------------------------------------------------- On Error GoTo ws_exit: Application.EnableEvents = False Columns(3).Sort key1:=Range("C2").Value, _ order1:=xlDescending, _ header:=xlYes ws_exit: Application.EnableEvents = True End Sub 'This is worksheet event code, which means that it needs to be 'placed in the appropriate worksheet code module, not a standard 'code module. To do this, right-click on the sheet tab, select 'the View Code option from the menu, and paste the code in. -- HTH Bob Phillips (replace xxxx in email address with googlemail if mailing direct) "Nikki Q" wrote in message ... is there anyway to have it automaticaly do it or will I have to continue to do it everytime i add more info to my spreadsheet? "Bob Phillips" wrote: Sort it descending, DataSort -- HTH Bob Phillips (replace xxxx in email address with googlemail if mailing direct) "Nikki Q" wrote in message ... I want to change the dates on my spread sheet so that the most current date always is on the top of my list. Is this possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Countif - recognition problems with dates | Excel Discussion (Misc queries) | |||
Having problems calculating dates in Excel. | Excel Worksheet Functions | |||
need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
Problems copying street addresses and dates | Excel Discussion (Misc queries) |