Sorting by date

[madbloke]

Cheers, that's done the trick (with a little tinkering).

There is one thing I can't fix, though.

The code I'm using pulls everything through from my alpha list to a ne
sheet, then sorts it by date.

Row 1 of the sheet is the headings. When the data is pulled through, i
starts in row 2, which is fine. When the date sorting code runs
however, it overwrites row 1. How can I stop that?

 

[Simon Lloyd]

Try this (untested), you need then to set the range that you are tryin
to sort

Sub Macro1()
'
' Macro1 Macro

Range("A2:A25").Select

Selection.Sort Key1:=Range("A2"), Order1:=xlAscending
Header:=xlGuess, OrderCustom:=1, MatchCase:=False
Orientation:=xlTopToBottom

End Su

 

[Tom Ogilvy]

Change
Header:=xlGuess

to

Header:=xlYes