Hi

I have a league table (attachment table named 'World Cup League'). It
updates scores as i enter them into a data table that precedes it
(titled 'Games Won'). I would like to be able to automatically sort the
'World Cup League' in descending order every time i enter data into the
'Games Won' table to save me having to sort it every time. Essentially
whenever i enter a number into this table, in any cell, the total
columns 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.Any ideas would be gratefully received as i am
trying to run a competition as a charity event and need to have to do
as little possible to save time. Thank you


+-------------------------------------------------------------------+
|Filename: World Cup.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4781 |
+-------------------------------------------------------------------+

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