Copy and paste a formula in a locked cell

N

nsnyder

I have protected a worksheet where I want users to be able to insert a new
column. The information is averaged over however many years are being used.
As a new column is added I need the the count in the aveage column to
increase by 1. Also I need to be able to copy formulas from locked cells
into the corresponding cells in the new column.
 
L

Luke M

For your average, instead of you might try using the COLUMNS function
somehow. Since this counts how many formulas are in a range, and would
increase in size if you insert a column within the range, it might just do
the trick.
 

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

Copy Worksheet of Locked Workbook 2
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Allowing row deletion in worksheet with locked cells 2
Possible to select a string in a locked cell? 1
formula for averages 1
Copy and Paste in Excel, copies cell and formula, but shows same v 3
corrupted formula in protected worksheet 21
copy and paste if 1

Top