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

Dealing with the error: unable to filter on excel hc home school 0
Quick Parts / SharePoint Library Update 0
Need Help with a VBA subroutine 0
Outlook Backup issues 0
Cumulative formula for word table 0
Copy addition formula of non-consecutive horizontal cells 2
Setting column width in a table with a macro is not working 0
Possible to select a string in a locked cell? 1

Top