Hi
In the second sheet col H8 - H135". I'm using a Macro to sort the values just read in from sheet1. But it seems that this formula doesn't want to allow the sort to work.
Sub Betterball_Score_Sort()
'
' Nett_Score_Sort Macro
' Macro recorded MC MOSTERT
'
'
ActiveSheet.Unprotect
Range("A8:J135").Select
Selection.Sort Key1:=Range("H8"), Order1:=xlDescending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
ActiveSheet.Protect
End Sub