move row automation

Kevin Wells

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?

Andrée Starå

Hi @Kevin Wells

The move/copy row feature doesn’t include the formulas but will use the formula autofill feature or Column Formula in the destination sheet.

Make sense?

Did that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Kevin Wells

The move/copy row feature doesn’t include the formulas but will use the formula autofill feature or Column Formula in the destination sheet.

Make sense?

Did that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Kevin Wells

It appears to have taken the column formulas from the original sheet I will attempt to update on the archive sheets and see if this solves the issue.

Thank you

Andrée Starå

@Kevin Wells

Excellent!

Happy to help!

How did it go?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Kevin Wells

Andree,

You were helpful, the sheets were using the original column formula because I copied the original sheet, I just had to redirect the referenced sheets to the archive sheets rather than the original, it actually worked out better since the row numbers change when archive.

Thanks for your assistance.

Kevin

Andrée Starå

@Kevin Wells

Glad to hear that it was helpful!

You're more than welcome!