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

The attached is a quick start, you will need to populate it with the
fixtures as they take place, as it stands it will not like postponed
fixtures


I would then Create a keystroke macro to sort the table by Pts the gD ,
but as I am sending you a spreadsheet decided not to include a macro,
its easy to do

Regards

Dav


+-------------------------------------------------------------------+
|Filename: Leaguetable.zip |
|Download: http://www.excelforum.com/attachment.php?postid=5008 |
+-------------------------------------------------------------------+

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

Thanks mate.


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

Dav
I meant to put into the previous post. I have the result page on a
different worksheet, will that matter? Is the formula the same?

Cheers mate.


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

the formula is fundamentally the same but you are looking at data on a
different sheet

so All the ranges $a$1:$a$1000 for example wil have to be name of data
sheet!$a$1:$a$1000

eg sheet2!$a$1:$a$1000

I think I have changed everything in attached

Regards

Dav


+-------------------------------------------------------------------+
|Filename: Leaguetable1.zip |
|Download: http://www.excelforum.com/attachment.php?postid=5010 |
+-------------------------------------------------------------------+

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

Hi,the position can be sorted automatically base on the points each team
get?

thanks

From,

Tan


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

the formula is fundamentally the same but you are looking at data on a
different sheet

so All the ranges $a$1:$a$1000 for example wil have to be name of data
sheet!$a$1:$a$1000

eg sheet2!$a$1:$a$1000

I think I have changed everything in attached

Regards

Dav


+-------------------------------------------------------------------+
|Filename: Leaguetable1.zip |
|Download: http://www.excelforum.com/attachment.php?postid=5010 |
+-------------------------------------------------------------------+

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