Hello my name is Ronnie. I am running a Premiership Predictascore game
this football season and want to add the Premiership table to the
workbook, so that once I have inputted the scores for that week into
the spreadsheet, it automatically puts the information into the
relevant box.

I have already the template for the table, the Goals for and against
columns are set up, the points column also is set up but I can not work
out what I need to do to get the information across.

For example, Arsenal win their first game of the season against Aston
Villa 3-0, I need the sheet to insert a '1' into the home win column
for Arsenal and a '1' in the away lost column for Aston Villa, and so
forth.

Is there anyone out there who can help me? I am pulling what hair I
have left out.....


--
ronaldo444
------------------------------------------------------------------------
ronaldo444's Profile: http://www.excelforum.com/member.php...o&userid=36233
View this thread: http://www.excelforum.com/showthread...hreadid=560172