Hi All, I have been running a football prediction league for the past 15 years and I have had to check everyones weekly predictions manually and then inputting onto an excel spread sheet to then form a table.So how it works is that I put onto facebook all the matches for that gameweek that the members can predict the score and the outcome on abd then they just add the scores to their own reply. With the replies I then compare them to the actual results and outcomes of the matches and manually input that data onto the spread sheet.
What I would like to be able to do is to be able to input the matches onto the worksheet so that I can update the table much more easierly. SO for instance if I have 10 members predicting I can then add the fixtures for each member with their predictions and as the scores come in I can add the up to date scores into another part of the workbook so that it will update the main table as the scores change .
I hope that makes sense. Below is the image of the table I use and that I input the score and outcomes manually which then populates the rest of the spread sheet.
What I would like to be able to do is to be able to input the matches onto the worksheet so that I can update the table much more easierly. SO for instance if I have 10 members predicting I can then add the fixtures for each member with their predictions and as the scores come in I can add the up to date scores into another part of the workbook so that it will update the main table as the scores change .
I hope that makes sense. Below is the image of the table I use and that I input the score and outcomes manually which then populates the rest of the spread sheet.
