Update spreadsheet with values from another sheet

[bertona]

I have a large spreadsheet (original) that needs to be updated with new rows from another sheet (updated)

Each sheet has four columns: manufacturer, name, device, model

I want to add rows from the updated sheet if the value of model does not exist in the original sheet.

This seems like it should be easy, but I can’t figure out how to do it.

[JohnSUN]

It’s really easy.

Just add all the data rows from the “updated” sheet to the end of the “original” sheet of the sheet and remove duplicates.

To remove duplicates use the Remove Duplicates Fast extension