title: Add new rows to existing table from external data with no duplicates
body: <p>I have a spreadsheet with existing workers' names, IDs, and addresses.</p>
  
  <p>These workers are hired and fired many times. </p>
  
  <p>I pull a report (external data from a website) that lists these workers' names, IDs, and addresses that are currently employed.</p>
  
  <p>Instead of adding and deleting the rows of these workers on my table(the table on the MASTER sheet) to match the report(the data on the EXTERNAL DATA sheet), I would like to add the rows of workers from the report(EXTERNAL DATA sheet) to my table(MASTER sheet) automatically without duplicates.</p>
  
  <p>The reason I need to add the whole row is because I have more columns in the table(on the MASTER sheet) so I can add their job title, shift, and incentive pay. So I need to delete the whole row when I delete the worker...</p>
  
  <p>I need some code to add rows from the external data table(EXTERNAL DATA sheet) on one sheet to my MASTER table on another sheet without duplicate workers.</p>
  
  <p>This code works great on my sheet now. I might be able to adapt this code with some help...</p>
  
  <pre><code>`Private Sub Worksheet_Change(ByVal Target As Range)
  ' Code to move row from FIRED sheet to MASTER sheet when “REHIRED” is 
  'selected in column J
    If Target.Column = 2 Then
  ' The line below is where I should change to something to compare if there 
  'is a new number 
  'in the "NUMBER" column of the "EXTERNAL DATA" sheet then move the row to  
  'the "MASTER" table. 
    If Target = "REHIRED" Then
      Application.EnableEvents = False
      nxtRow = Sheets("MASTER").Range("H" &amp; Rows.Count).End(xlUp).Row + 1
      Target.EntireRow.Copy _
      Destination:=Sheets("MASTER").Range("A" &amp; nxtRow)
      Target.EntireRow.Delete
    End If
   End If
   Application.EnableEvents = True
  End If
  End Sub`
  </code></pre>
  
  <p>I hope this makes sense. </p>