Macro to give me a points total for prediction league

[ladbroke]

Hi all,

I am running a Prediction League and was wondering if someone could help me with a macro that I could run that will help me.
I currently using formulas in various cells but I think (although I've hidden the columns) it looks very untidy still.

Basically, below is a screenshot of how I am wanting to redesign my layout.

In the first row I want the participants total points above their names.

Points are awarded as follows:

5 for correct score/result (ie Person B in game 1)
4 points for correct result with 1 team correct goals (ie Person A game 2 - home team scored 0, prediction 0)
3 points for correct result but not score line (ie Person A game 3)
1 point for correct goals scored for 1 team (ie Person B game 3)

I am pretty sure its possible but its been a very long time (I am talking 10 years and even then I was a complete novice and needed help) since I even looked at code for VBA and wouldn't even know where to begin. If there is a superstar out there that can help me I would be truly amazed and happy.
I would need the code to appreciate new games and new participants too if possible.

Many Thanks.

With the following example, Person A would have 7 points, whilst Person B would have 9.


pic upload

 

[ladbroke]

Is this possible?

I would obviously consider a formula if it can keep to one cell. Just thought a macro would be easier to create.

In a previous sheet I have created, I had something like 9 columns that had various formulas that tried to come to a conclusion but it became very hard to add a new user easily as I had to unhide columns, copy and paste and edit formulas to match the target cells.

Ideally, I really would like to keep it to one cell.

Please help me :D