Copy row automation/keeping rows linked
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?
Tags:
Answers
-
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!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives