Merging two sheets, overwriting matching records

Hi everyone,

I'm sure this is fairly simple, and has probably been answered here many times. However, I'm not quite sure how to search for this one. What I need to do is this: I have this sheet, which is just an example (the actual one has many more records).
subset.xlsx

I received this sheet (again, example)...
new.xlsx

I need to add the new sheet to the old sheet, so that they are merged into one sheet. Also, if the same "LOC" appears in both sheets, I need to overwrite all the records for that "LOC" in the old sheet with the records from the new sheet.

Sorry to ask a potentially stupid question!

Looking at the uploaded files using filter I see the file "subset.xlsx" contains only "BRAG" and "CONG" in column A. The file "new.xlsx" contains "CONG" and "FERN" in column A.

Have I understood you right when you wish to delete all rows with "CONG" in file "subset.xlsx" and replace them with all rows containing "CONG" from file "new.xlsx" and also adding all rows containing "FERN" from "new.xlxs" to file "subset.xlsx"?

Alf

Hi Alf- yes, and I have actually already solved...I was trying to delete this thread; sorry to ask an even stupider question, but is there a way to?? I tried to use "edit post" but saw no option for delete. Thanks for your reply!