Good Morning I have a complicated sheet that I need some expert help with. I have a league i am running and trying to calculate Points for and Points Against. I already have a Macro that figures out the total score for each team. So in range AE1:AP5 (AE1:AP1 = the team number (1-12)) then in AE5:AP5= the teams score. in Range AH87:AS87 = the team number - So AE5=AH90 (i am in the third week) AE6=AI90 AE7=AJ90 .... and so on But every time i run the macro i need it to look to the next blank cell ( in this case AH91 for team 1, AI91 for team 2) Below is a screen shot AH86 AH87 AG86 1 2 3 4 5 6 7 8 9 10 11 12 Week 1 241 218 210 238 208 228 204 216 220 228 215 236 Week 2 191 227 244 230 230 216 253 210 249 229 226 208 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 Week 9 Week 10 Week 11
Last edited:
