I have my own football league table which works without macros. It isn't
that complicated. As Bob suggests, it basically has one "hidden" table
and another table "sorted" in order to view

It has a list of fixtures. As you enter results the table updates based
on 3 points for a win and usual rules to split ties, i.e. goal
difference followed by goals scored.

If you'd like a copy send me a PM with your email address


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=557213