Automatic Sort

[Chris]

OK... I have a schedule file that gets updated hourly by non-excel type
people. I want the spreadsheet to sort by column N every time a change,
addition, deletion of anything is done to the spreadsheet... how do I go
about doing this/

[Carim]

Hi Chris,

With an event macro stored in the worksheet module :
Private Sub Worksheet_Calculate()
' Adjust to Your Range
Selection.Sort Key1:=Range("YourCell"), Order1:=Ord, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
End Sub

HTH
Cheers
Carim

[Chris]

Great... last question... where do I learn this stuff.... I'm an access
programmer but this is a little different...

"Carim" wrote:

>
> Hi Chris,
>
> With an event macro stored in the worksheet module :
> Private Sub Worksheet_Calculate()
> ' Adjust to Your Range
> Selection.Sort Key1:=Range("YourCell"), Order1:=Ord,
> Header:=xlGuess, _
> OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
> End Sub
>
> HTH
> Cheers
> Carim
>
>
> --
> Carim
> ------------------------------------------------------------------------
> Carim's Profile: http://www.excelforum.com/member.php...o&userid=33259
> View this thread: http://www.excelforum.com/showthread...hreadid=532745
>
>

[Carim]

There are many good sites ...
One that I particularly love is Chip's :
http://www.cpearson.com/excel/topic.htm

It is packed with plenty of tricks ...

HTH
Cheers
Carim

[Chris]

How do I adjust the range... I want the range to sort by column C... I tried


Private Sub Worksheet_Calculate()
Selection.Sort Key1:=Range("C"), Order1:=Ord,
Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
End Sub

I also tried:
Private Sub Worksheet_Calculate()
Selection.Sort Key1:=Range("C2,C300"), Order1:=Ord,
Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
End Sub

I also tried:
Private Sub Worksheet_Calculate()
Selection.Sort Key1:=Range("C2:C300"), Order1:=Ord,
Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
End Sub







"Carim" wrote:

>
> There are many good sites ...
> One that I particularly love is Chip's :
> http://www.cpearson.com/excel/topic.htm
>
> It is packed with plenty of tricks ...
>
> HTH
> Cheers
> Carim
>
>
>
> --
> Carim
> ------------------------------------------------------------------------
> Carim's Profile: http://www.excelforum.com/member.php...o&userid=33259
> View this thread: http://www.excelforum.com/showthread...hreadid=532745
>
>