leandrocg

you need to copy values. The sub Below copies from range
G1 to I8 to A1:c8 and sorts the results

You can adjust this better yourself

Sub SortLeague()
Range("A1").Select
Range("A1:C8").Value = Range("G1:I8").Value
Selection.Sort Key1:=Range("C2"), Order1:=xlDescending,
Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False,
Orientation:=xlTopToBottom

End Sub

Regards
Peter
-----Original Message-----
hi i have seen and tried the auto sort posts here but
none seem to work
in mine

then i tried in a new sheet and found that those worked
only in
numbers, when i try sorting a formula it doesnt work

i have a table like this:

Name Games Points
Team1 2 9
Team2 2 4
Team3 2 1

and so on; as the points are formulas, related to the
game results wich
there are also in the same sheet

is there a way to auto sort those point columns among
with the team
name column? the columns are N8 up to V16


---
Message posted from http://www.ExcelForum.com/

.