Blade
This macro does what you want. I assumed the following:
Both the Games Won and World Cup League tables are on the same sheet.
The range of the Games Won table is named GamesWon.
The range of the World Cup League table is named WorldCupLeague.
The World Cup League table has its headers in Row 1 and the Rank Order
column is Column H.
Note that this is a sheet event macro and must be placed in the sheet module
of the sheet that holds the two tables. To access that module, right-click
on the sheet tab of that sheet, select View Code and paste this macro into
that module. Click on the "X" in the top right corner to return to the
sheet. Post back if you need help with changing this macro to work with
your data layout. HTH Otto
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Value = "" Then Exit Sub
If Not Intersect(Target, Range("GamesWon")) Is Nothing Then _
Range("WorldCupLeague").Sort Key1:=Range("H2"), _
Order1:=xlDescending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, _
Orientation:=xlTopToBottom
End Sub
"Blade2304" wrote
in message ...

Whenever i enter something into the 'Games Won' table. By entering a
number into this table in any cell totals change. These totals then
transfer into the 'World Cup League' table and therefore the
competitors need sorting into rank order with most points first. I
know i could do this with manually sorting each time i enter new data
but it would be nice if it did it automatically. Also there may be
blank rows in this table so i dont want them to be included in this
sort.


--
Blade2304
------------------------------------------------------------------------
Blade2304's Profile:
http://www.excelforum.com/member.php...o&userid=33492
View this thread: http://www.excelforum.com/showthread...hreadid=543078