Hello

I've offered to do a spreadheet for a charity football tourament. There are
16 teams, 4 tables. I've done the following:

1. Created a schedule of games for all teams were the score is populated
2. This then updates the tables based on a win (3 points), a draw (1 point),
a loss (0 points).

It's working well but I spotted that the table is static. As the four teams
accumlate points over the games (e.g. in Table A), the team with the most
points at that stage should be at the top of the table. This changeable and
therefore I need a method to dynamically sort the table as the results are
inputed.

At present the third team in Table A stays third regardless of the points.
I therefore need a dynamic method to sort the table on points as each teams
score is populated. I could do this manually, but I'll be playing (badly)
and also helping elsewhere. The score keeper has no spreadsheet skills and is
just about OK with populating the individual scores - but I don't want her to
keep sorting because she might make an unforeseen error.

Can the 'sort' be done dynamically? I hope that made sense!

I'd appreciate any thoughts or guidance.

Thanks to all who reply,
Hardip