Auto sort?

[slam]

I have a worksheet called “Drivers & Standings” with data from A1 through AB18. All of the data on this worksheet is pulled from other worksheets – there is no manual entry on this one. When the other worksheets are updated with information used by this one, I’d like this one to automatically sort on column X. However, column A must not be included in the sort (it is static). Row 1 is the header row, but there is also a hidden row 2 that should not be included in the sort.

Any help would be greatly appreciated.

 

[jae113]

Can you run a macro on it that will auto sort it? You select all the cells that should be sorted, Say B1 : AB200. Then go to sort and make sure you select that your data has headers. Then just make the header also include the hidden row 2.

Would that worrk?

 

[slam]

Can you run a macro on it that will auto sort it? You select all the cells that should be sorted, Say B1 : AB200. Then go to sort and make sure you select that your data has headers. Then just make the header also include the hidden row 2.

Would that worrk?

Before I try this, and I think creating the macro would be easy enough, how do I make it run automatically? Like upon entering the worksheet for instance?

 

[slam]

Anyone? I feel like there must be some VB code that would do this? Thanks

 

[VoG]

Try this: right click the Drivers & Standings tab, select View Code and paste in

Private Sub Worksheet_Activate()
Range("B3:AB18").Sort Key1:=Range("X3"), Order1:=xlAscending, _
    Header:=xlNo, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
End Sub

 

[slam]

Try this: right click the Drivers & Standings tab, select View Code and paste in

Private Sub Worksheet_Activate()
Range("B3:AB18").Sort Key1:=Range("X3"), Order1:=xlAscending, _
    Header:=xlNo, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
End Sub

Excellent, thanks!