Automate data flow from Source to Target sheet (based on New & Edit criteria)
Looking to automate data flow from Source to Target sheet based on below criteria
New row: If new row added in source sheet then new row should be added to target sheet. I should able to config what columns need to move target sheet.
Update/Edit: if any row get updated in source sheet then corresponding row in target sheet should get updated if the primary key of source and target sheet matches. I should able to config what columns need to get updated.
Is it possible to automate above criteria, I looked into "Data Shuttle" and sheet automation features but no luck.
Thank you in advance.
Help Article Resources
Check out the Formula Handbook template!