recording macros/formulas

[biglb79]

I'm trying to record a macro for rolling forward our financial statements. In doing so, I have to copy column D then insert copied cells. I then hide column P and in column FY it has a calculation for column D and column O. when recording the macro I highlighted all the cells and did a find/replace for E to D and P to O, but then when hitting the roll forward button a few times the formulas do not stay on columns D and O. how do I get that formula to stay the same?

thanks