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.

Thanks very much for emailing me the spreadsheet - it runs fine on
the work pcs (which don't allow macros). I especially like how easy it
is to add/delete teams.

I'd like to know more about how it works - where is the hidden table?

The only downside in my opinion is that it doesn't create the fixtures
- ideally a fixture grid (home teams-vertical, away teams-horizontal).
I have a spreadsheet (with macros thought) that does that which I'd
gladly share - I'd like to have a go at merging elements of both
spreadsheets ?

Alternatively, could Bob incorporate a fixture grid into the
spreadsheet he's developing ?


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