Copy cell with Row Insert

M

Mike Kiekover

Here's the scenario. I have a spreadsheet with formulas in each row. The formulas are relative only to the row they are in. I also protect the workbook so cells with formulas are protected, columns can not be added and hidden stuff can not be un-hidden. The Basic template for this workbook has about 20 rows. The jobs this will be used on will require a varying number of rows, up to several hundred, and different for each job. I don't want to create a template with 200-300 rows, if only 20 are needed some of the time.

Here's the dilemma, with the protection settings I have set, the user can add rows as needed, but the problem is that the formulas are not copied into the new rows. The user can't copy and paste them, or auto fill, because those cells are locked.

Is there a way to make one cell (or I guess all cells if necessary) copy values into the new row when using the basic "insert" command to insert a row?

Thanks

Mike K
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Inserting a Copied Row inside a table 6
Drop down list control value in vba 2
Compare two different workbook sheet to show the difference in text 0
Copy Existing Formula Into New Row 0
Why no "insert copied cells"? 1
Excel macro code for copying data to a cell reference which is set byvalues in two separate cells in 3
hidden rows, column copy-paste 0
Macro to fill down automatically the number of rows in a spreadsheet 1

Top