Replace data in cells of moved row for formula of cells above in destination sheet
I've created an automation for moving a row to another sheet. After moving I want in some cells that the original data that came from the source sheet will be replaced for a formula as in the above rows of the destination sheet. Until now it ignores these formula's and keeps the original data.
Is it possible to let this original data automatically be replaced by the above formula's?
Many thanks in advance,
Mark van den Berg
Help Article Resources
Check out the Formula Handbook template!