Automatic sort and update league table in Excel

[Raju Chacha]

I'm just getting up to speed with Excel and as an exercise I'm trying to implement a simple league table. What I'd like to know is how to create 'dynamically' a ranking table like the one shown below.
Pos || Player ||Points
1 Tom 124
2 Linda 122
3 Harry 107
4 Jayne 100
4 Bob 100
5 Steve 89
6 Mark 88
7 John 80
8 Angie 77
9 Andrew 71

The table is sorted on the points column, the values for which are referenced from another sheet. Ideally I'd Like the table to be sorted automatically as players points total change (based on calculations in another sheet). Can I do this with formulas/macros or will it require some VBA code? So if you guys have any information then please let me know.

[Bontu]

You can do this with a worksheet change macro in the sheet module.
So for that just Right click on the sheet tab>view code>left window use worksheet>right window select and write your code to sort.

[GaganjyotTechie]

I think you have to make the use of these macros may this will work for sort and update league table

Private Sub Worksheet_Calculate()
With Me
.Columns("A:B").Sort Key1:=Range("B2"), _
Order1:=xlDescending, _
Key2:=Range("A2"), _
Order2:=xlAscending, _
Header:=xlYes
End With
End Sub

'This is worksheet event code, which means that it needs to be placed in the appropriate worksheet code module, not a standard code module. To do this, right-click on the sheet tab, select the View Code option from the menu, and paste the code in.

[Hollyn]

Maybe best to stop the cascade of events, you can also try this one also.

Private Sub Worksheet_Calculate()
Application.EnableEvents = False
With Me
.Columns("A:B").Sort Key1:=Range("B2"), _
Order1:=xlDescending, _
Key2:=Range("A2"), _
Order2:=xlAscending, _
Header:=xlYes
End With
Application.EnableEvents = True
End Sub