I've been spending a silly amount of time trying to get this vba to work (probably more than I could have done it manually over a whole season) and now its bugging me to get it working.
I have each match played on the left, Result, scores
i.e
United v swansea HW 2 1
leicster v everton D 2 2
arsenal v chelsea AW 1 2
etc etc
then next to that each player guesses the match result, score and the total points is calculated below.
Basically its 3 points for getting the result bang on, 2 points for guessing a draw (incorrect score though) and 1 point for guessing an Away win or home win without getting the correct score.
If anyone could point me in the right direction or take a look at the spreadsheet i'd be very grateful.
Bookmarks