Excel 2007 : Updating results across sheets automatically?

**BigArty** · 06-24-2008, 08:51 PM

Hi guys i am a new user to excel and forgive me if this is too easy.

From the attached sheet ( its a bit of a mess), i am trying out a football ratings system.
Basically i am trying to auto update the home and away power ratings after each game from entering the results each week.
After the results are entered in the second game (A16 to E21),
the HOME ADJ (Column L) and AWAY ADJ (Column N) are updated.
I would then like to add these to the POWER RATINGS on Sheet2 and have the value automatically updated.
The same for the next match and so on...

Clear as mud!! LOL

I dont know if i am approaching this correctly from the start but, hey you gotta start somewhere!

Many thanks for your time it is much appreciated.

**mudraker** · 06-24-2008, 09:30 PM

BigArty

Welcome to Exceltip forum

Please take a couple of minutes and read the Forum Rules then edit your thread title by following the instructions in the rules (Rule 1)

**BigArty** · 06-25-2008, 08:11 AM

From my updated spreadsheet (attached), i am calculating the ADJ.HOME and ADJ.AWAY on the SCORES sheet.
I need a formula that will add these to the NEW POWER RATING on the TABLE sheet which can automatically update as the scores are entered for each team.

Sorry for the last post!!

**davesexcel** · 06-25-2008, 08:19 AM

Originally Posted by BigArty

From my updated spreadsheet (attached), i am calculating the ADJ.HOME and ADJ.AWAY on the SCORES sheet.
I need a formula that will add these to the NEW POWER RATING on the TABLE sheet which can automatically update as the scores are entered for each team.

Sorry for the last post!!

I believe the request was to change the title of your thread,"Please help guys" just won't work.....

**Simon Lloyd** · 07-04-2008, 07:53 PM

Title changed as the 2 hour edit window had passed!

BigArty, please give the forum rules another once over believe it or not they are there to help you get the best from this forum.