Good morning
I am working on Excel 07. and need to do the following
For a 12 team sports league that i want to caculate the teams total score for PTs for and PTs against
I have a Macro puts the teams total score in AE5:AP5 (Team 1-Team 12)
I would like the teams score to be added to cell AH106 for Team 1, AI106 for team 2, and so on to AS106 for Team 12. I will up date the table automatically each week so i need this to happen each time i run the macro
then i need to compare the schedule below to caculate for Teams that play each other.
this number needs to be added to the value in cells AF108 for Team 1, AF109 for team2, and so on AF119 for Team 12.
AE26:AG31 -
<tbody>
</tbody>
I am working on Excel 07. and need to do the following
For a 12 team sports league that i want to caculate the teams total score for PTs for and PTs against
I have a Macro puts the teams total score in AE5:AP5 (Team 1-Team 12)
I would like the teams score to be added to cell AH106 for Team 1, AI106 for team 2, and so on to AS106 for Team 12. I will up date the table automatically each week so i need this to happen each time i run the macro
then i need to compare the schedule below to caculate for Teams that play each other.
this number needs to be added to the value in cells AF108 for Team 1, AF109 for team2, and so on AF119 for Team 12.
AE26:AG31 -
11 | vs | 12 |
7 | vs | 8 |
1 | vs | 2 |
9 | vs | 10 |
5 | vs | 6 |
3 | vs | 4 |
<tbody>
</tbody>