Hello Again,
I've got the following macro which sorts people by name on sheet 1.
I've also got 5 identical sheets in the workbook, which represent 5 weeks.
I would like to be able to sort the same range on all 5 sheets simultaneously with the click of one button.
Sub Sort_by_NAME()
Range("A3:R112").Sort Key1:=Range("A3"), Order1:=xlAscending, _
Key2:=Range("B3"), Order2:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, _
Orientation:=xlTopToBottom
Range("A3").Select
End Sub
Many thanks,
K.
I've got the following macro which sorts people by name on sheet 1.
I've also got 5 identical sheets in the workbook, which represent 5 weeks.
I would like to be able to sort the same range on all 5 sheets simultaneously with the click of one button.
Sub Sort_by_NAME()
Range("A3:R112").Sort Key1:=Range("A3"), Order1:=xlAscending, _
Key2:=Range("B3"), Order2:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, _
Orientation:=xlTopToBottom
Range("A3").Select
End Sub
Many thanks,
K.