My apologies for dumpster diving this thread but I have a small request from rylo, if he's still around, or anyone else. rylo provided me with this macro a couple years ago and my spread sheet changed very slightly. I attempted to make the minor change without success.
My change was simply adding a few rows to the very top of the "Weeks" sheets which disrupted the macro calculation on the "Rankings" sheet. How can I change the code to calculate the "Weeks" sheets starting in row 7 instead of row 4, as before?
I'll attach what the new sheet looks like. You can see rows 1, 2 and 3 were simply inserted into the top of the Week(s) sheet and that messed up the macro calculation. The macro was set up so the "Rankings" sheet will the take data from columns B, C, D, E and F in the subsequent "Weeks" sheets. To see how the macro currently works, delete the first three rows of the Week 1 sheet and run the macro..results will show up in the Rankings sheet.
Bookmarks