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?

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?

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

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?

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?