Hi Tony,
You'll have to be more specific, but you might find the answers to such problems
as inserting rows, using OFFSET with formulas. And you will probably find why
extending formulas and does not work for you. -- if any of those are the problem. http://www.mvps.org/dmcritchie/excel/insrtrow.htm
I don't know what you mean by locking the sheet, have you turned on sheet protection
or have merged cells in your copy..
