I have a client that wants to protect formulas on a spreadsheet and allow users to insert duplicate rows but only with existing formulas where they exist. In other words, I need to insert a row above row 7, and A7-D7 are data entry cells, but E7-G7 are formulas and need to be copied to the new row.
What's happening is that he has a very complex spreadsheet with multiple tabs linked to each other with very complex formulas, but he needs to allow users to insert and add lines. He has trained them to copy and insert rows, but also has to allow them to unprotect the entire sheet in order to copy and insert rows with set formulas. What is happening is that when they unprotect to do so, a formula can be accidentally erased without anyone realizing it.
I seemed to think that it is just a training or proofing issue since multiple users have to be trusted to copy and paste the formulas correctly, but wanted to find out if there is a way to keep the sheet protected and insert duplicate rows as needed.
I am using excel 2003. Thanks!
What's happening is that he has a very complex spreadsheet with multiple tabs linked to each other with very complex formulas, but he needs to allow users to insert and add lines. He has trained them to copy and insert rows, but also has to allow them to unprotect the entire sheet in order to copy and insert rows with set formulas. What is happening is that when they unprotect to do so, a formula can be accidentally erased without anyone realizing it.
I seemed to think that it is just a training or proofing issue since multiple users have to be trusted to copy and paste the formulas correctly, but wanted to find out if there is a way to keep the sheet protected and insert duplicate rows as needed.
I am using excel 2003. Thanks!