Sorting by date
 

Hi,

I have an Excel sheet with a list of approx 150 documents i
alphabetical order, and column G contains the date the document wa
last updated. What I need to do is put some code into a worksheet tha
will pull each row through and then sort it by date. Any ideas

--
madblok
-----------------------------------------------------------------------
madbloke's Profile: http://www.excelforum.com/member.php...fo&userid=1442
View this thread: http://www.excelforum.com/showthread.php?threadid=26637

Sorting by date
 

Not sure what pull each row through means, but have you tried the macro
recorder?

--

HTH

RP

"madbloke" wrote in message
...

Hi,

I have an Excel sheet with a list of approx 150 documents in
alphabetical order, and column G contains the date the document was
last updated. What I need to do is put some code into a worksheet that
will pull each row through and then sort it by date. Any ideas?


--
madbloke
------------------------------------------------------------------------
madbloke's Profile:
http://www.excelforum.com/member.php...o&userid=14422
View this thread: http://www.excelforum.com/showthread...hreadid=266370

Sorting by date
 

Hi MadBloke,

At a guess, try something like:

Sub Tester()
Range("G1").CurrentRegion.Sort Key1:=Range("G2"), _
Order1:=xlAscending, _
Header:=xlGuess, _
OrderCustom:=1, _
MatchCase:=False, _
Orientation:=xlTopToBottom
End Sub

---
Regards,
Norman



"madbloke" wrote in message
...

Hi,

I have an Excel sheet with a list of approx 150 documents in
alphabetical order, and column G contains the date the document was
last updated. What I need to do is put some code into a worksheet that
will pull each row through and then sort it by date. Any ideas?


--
madbloke
------------------------------------------------------------------------
madbloke's Profile:
http://www.excelforum.com/member.php...o&userid=14422
View this thread: http://www.excelforum.com/showthread...hreadid=266370