League table

[Guest]

I'm trying to put a football league table together, which i'd like to include: the team, matches played, won, drawn, lossed, goals for, goals against, goal difference and points. i've pretty much done most of it but my main two problems are when there's no score entered for each match it enters in the table as a draw and my other issue is once a score is entered i can't get the teams to move up and down the league automatically. is there a way to lock the formulas for each team when they move up and down

Please help my email is (e-mail address removed)

Regard

 

[Don Guillett]

multi posted with different subject lines

--
Don Guillett
SalesAid Software
(e-mail address removed)

I'm trying to put a football league table together, which i'd like to

include: the team, matches played, won, drawn, lossed, goals for, goals
against, goal difference and points. i've pretty much done most of it but my
main two problems are when there's no score entered for each match it enters
in the table as a draw and my other issue is once a score is entered i can't
get the teams to move up and down the league automatically. is there a way
to lock the formulas for each team when they move up and down?