sort automatically

[patxecs]

I have a soccer table and I want it to automatically sort who is in first place, second, etc, when I change the values.

My table is this:

"Casa" are the home games; "Fora" are away games.
J = Games played
V = Victory
E = Draw
D = Defeat
GM = Goals scored
GS = Goals conceded
DIF = Goal difference
P = Points

The table is full of functions. If I change the goals scored in away games and the number of draws for example, it will change all the totals.

I want the points to sort automatically so the first team is the one with more points. How can I do this?

 

[mikerickson]

Sorting upon data entry is not usually a good idea.
It takes the value the user entered and immediately moves it somewhere else, making it harder for the user to check for a mistyped entry.

 

[patxecs]

So it's better that I sort it after making changes?

 

[mikerickson]

The sort could be triggered by a button or double clicking a cell or a variety of methods. My point is that entering data is a poor trigger for a sort routine.

As for sorting your data. How do you determine whether one team is above another?
It might be easier if there were a (total) Percentage of Games Won column.

 

[patxecs]

The teams are sorted by the number of points in column named "P"

The first team is the one with more points.

Maybe I can use a button to sort it whenever I want?

 

[patxecs]

In this case, column named "P" is the column U.

 

[mikerickson]

This routine will sort the file, a button from the forms menu could be assigned to this macro.

Sub sortResults()
    With Range(Range("P3"), .Cells(Rows.Count, 1).End(xlUp))
        .Sort Key:=Range("P3"), order1:=xlDescending, Header:=xlNo
    End With
End Sub

 

[patxecs]

Thank you very much