Copy entry into a range if there is no duplication

Hi,
I'm trying to create a "dynamic" db. Db is located in sheet1. Into sheet2, which has the same headers as sheet1, new monthly data will be thrown. Sheet1 needs to pull only entries which aren't already in db, hence no duplication.
Hope I've managed to explain myself

Please Login or Register  to view this content.

Gi, GIS2013,

maybe like this:

Please Login or Register  to view this content.

Ciao,
Holger

Hi there Holger, could you please adjust your code in accordance with my sample (I've already done part of this). Cheers.

Hi, GIS2013,

sorry but I donīt understand what you want me to do: you asked for a code to compare the values in Columns A of sheets db and feed, thatīs what the code does. This doesnīt seem to be what you are after. So you would have to explain what you really want.

Ciao,
Holger

Sure. I should add a sample file in the first place . Anyway, if you look at "db" you can see 8 entries. In "feed" there are currently 2 entries. I need the code to copy from "feed" to "db" any entry upon the condition that it's not already in "db". And so the sub should not copy worksheets("feed").range("a2:c2") since it's already in "db", but it should copy worksheets("feed").range("a3:c3") into a new line in "db" (hence to become the last line). Thanks.

**"feed"'s entry to be declared non-duplicated (and so be copied) if at least one of its values (in column A or B or C) are not exactly as in "db".

Hi, GIS2013,

maybe like this:

Please Login or Register  to view this content.

Ciao,
Holger

Cheers! always great to learn from you