Unlock, Add new row, copy formula, re-protect formulas

December 29, 2013 at 13:24:14
Specs: Macintosh

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!

See More: Unlock, Add new row, copy formula, re-protect formulas

Report •

December 29, 2013 at 13:43:20

Report •
Related Solutions

Ask Question