I am working on creating a basketball stat sheet template and need some help with a macro. I attached an image of what I have so far. Every number on the attached picture is either an IF Formula or a basic addition/multiplication formula. Each row is essentially another basketball game.
I have my formulas protected so that I don't accidentally delete the formulas I have built in.
What I need to do is make it user friendly for someone with limited Excel knowledge to use.
I'd like them to be able to add in a new row under row 4 (for the next game), with the formulas and formatting copied to that new row, and then have those formulas protected and locked.
I also need rows 6, 7, and 9 (SUM/AVERAGE formulas) to calculate in the figures from the new row.
Is there any way to do this?