Hello! 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?

Thank you!

~Taylor

Ask Your Question

Weekly Poll

Have you played Jackbox during the pandemic?

Discuss in The Lounge

Poll History