Copy row automation/keeping rows linked

Options
tchav
tchav ✭✭✭✭

Is there a way to keep rows linked from the parent sheet to destination sheet? So if we make changes to the row after the copying takes place to make sure that the destination sheet is also updated with any updates that happen in the row from the parent sheet?

Answers

  • markkrebs
    markkrebs ✭✭✭✭✭✭
    Options

    you can do this with a datamesh.

    If you dont own datamesh, you can do index(match()) column formulas on everything except the unique identifier. That way new items are copied over and the data updates as the master source is updated. dont use Vlookup!