Thread: Auto rank/sort

Hi,

I have read many posts but cant apply to them my issue and also need to understand it so I can change the range when new people join. See attached spreadsheet for the WC2010. The first tab pulls in the scores of individuals but want them to auto resort dependent on their ranking. So in this example Bryony and Foxy would be automatically top. Obviously it will need to calculate when people are tied.

Will it include any new people I add too?

Many thanks

This macro will automatically sort the data for you..

Sub Sort()
    Range("c4:d12").Sort _
    Key1:=Range("d4"), Order1:=xlDescending, _
    Key2:=Range("d12"), Order2:=xlDescending
End Sub

Thx - will give it a try

Thanks it works great when I run the macro, however how do I make it run automatically? Either when the stats change or when the file is opened? Thanks