Hello Everyone,

I have a document which users will be using on a regular basis. I have locked the sheet so no data can be changed unless allowed via the cell being unlocked. I want the users to be able to insert a column but when doing so, the formulas from the column to the left or right do not copy over. Is there a Non-VBA way of doing this. I cannot use macros either.

Thank you for any help.