Creating one row in one table creates another row in another table

You could use a formula to duplicate the data into another sheet, but that can cause issues if you add additional columns to the second sheet. Also some ideas here if you want to do this with scripting. It’s a little more work, but prevents issues by only adding new rows to the other sheets. Deletes or resorting won’t affect anything in the second sheet.

1 Like