Copy row of data to another worksheet only when the data does not exist in that worksheet

[Podder1965]

Hi,
I am trying to copy rows of new data from one worksheet to a Master worksheet only when the new data does not exist in the Master worksheet.
Currently, I have the following setup in the Master worksheet:
Country Colour Type
England Red 2
Scotland Blue 2
Scotland Blue 3
Scotland Red 7
England Blue 4

I then get new data with the same format as above, in another worksheet
Country Colour Type
France Brown 3
Scotland Blue 2
Germany White 4

What I want to achieve (if possible) is to determine if the rows of new data exist in the Master worksheet and if so ignore them but if they don't then copy them to the existing data.
So the above Master worksheet would look like this:
Country Colour Type
England Red 2
Scotland Blue 2
Scotland Blue 3
Scotland Red 7
England Blue 4
France Brown 3
Germany White 4

Thanks in advance

 

[Osvaldo Palmeiro]

Hi. Try this code, please.
As you run the code the sheet to copy data from should be the active one.

Sub ReplicateData()
 Dim cct As Range
  For Each cct In Range("A2:A" & Cells(Rows.Count, 1).End(3).Row)
   If Application.CountIf(Sheets("Master").[A:A], cct.Value) = 0 Then cct.Copy Sheets("Master").Cells(Rows.Count, 1).End(3)(2)
  Next cct
End Sub

 

[Podder1965]

Hi. Try this code, please.
As you run the code the sheet to copy data from should be the active one.

Sub ReplicateData()
 Dim cct As Range
  For Each cct In Range("A2:A" & Cells(Rows.Count, 1).End(3).Row)
   If Application.CountIf(Sheets("Master").[A:A], cct.Value) = 0 Then cct.Copy Sheets("Master").Cells(Rows.Count, 1).End(3)(2)
  Next cct
End Sub

Osvaldo,
Works perfectly,
Cheers