Add new rows to existing sheet

[Andrew69]

Hi,

I want to combine imported data into a master list using VBa, and have added an example file. Note that I want to add only rows that don't already appear, so in effect create a very simple database using one primary key.

Please help as I'm stuck, note that the rel life file is large with 15+ columns.

Example file is Master Data which is existing List, Import Data in Orange with some new rows, and Sheet 3 the expected results.


Thanks Andrew

P.S. Happy to use a macro which adds to the end of the Master Data.