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..
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.