Copy and paste a formula in a locked cell
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. |
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. |
All times are GMT +1. The time now is 06:42 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com