Trying to auto-update NFL stats (PF) and (PA) on my NFL spreadsheet.
__A___B__C____D______E____
1 115 207 15 =A1+C1 =B1+C2
2 148 202 28 =A2+C2 =B2+C1
|
|
(Repeat for other 13 games)
After the game between teams 1 and 2, A1(PF) and B1(PA) change
depending on the score of the game (C1 is team 1's score and C2
is team 2's score). I want to paste special as values columns D and E
over columns A and B.
How do I 1) avoid circular reference and 2) clear columns D and E
(except for the formulas) immediately after the values are pasted to
columns A to B to prevent the new pasted values from being acted on
again in columns D and E?
Of course, maybe there is an easier way to perform these calculations.
Apprciate any help from the forum.
Ken
__A___B__C____D______E____
1 115 207 15 =A1+C1 =B1+C2
2 148 202 28 =A2+C2 =B2+C1
|
|
(Repeat for other 13 games)
After the game between teams 1 and 2, A1(PF) and B1(PA) change
depending on the score of the game (C1 is team 1's score and C2
is team 2's score). I want to paste special as values columns D and E
over columns A and B.
How do I 1) avoid circular reference and 2) clear columns D and E
(except for the formulas) immediately after the values are pasted to
columns A to B to prevent the new pasted values from being acted on
again in columns D and E?
Of course, maybe there is an easier way to perform these calculations.
Apprciate any help from the forum.
Ken