Update Rows

(0) Share

Report

Posted on by Peaches_046

Hello!

Wondering if someone can help. I am trying to consolidate data from multiple worksheets with multiple tables into one main worksheet with similar tables.
I managed to create a condition to map table names so table from one sheet will update in the same table from another sheet.
My problem is that each table have different row

names and when I update row, they are deleting the existing data for other rows.
I’m not sure if what I am doing is possible, I have tried filters and conditions but no luck.

I’m assuming my update row function is looking for all the rows in the main sheet inside the sheets being added under the trigger. So if the new sheet only has CDE, it the main sheet with ABCDE deletes the data from AB and replaces it with empty CDE

https://docs.google.com/file/d/1tE9-S2gcSWWkAt759LR7xWBHEurw2UP1/edit?usp=docslist_api&filetype=msword

I have the same question (0)