Copy and paste a formula in a locked cell
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.
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
"nsnyder" wrote:
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.
|