move row automation

I have 2 different sheets (Call them A and B) with a formula on A to VLOOKUP items on sheet B, this works correctly. I am using automation to move a row based on completed items onto a separate archive sheets (A archive & B archive).

When the cells move the formulas now result in INVALID because the Vlookup original location is also being moved. Is there a way to preserve the value of the formula when moving the row rather than moving the formula?

Best Answer