title: Macro to copy data from one sheet to another, only if not already present
body: <p>I am struggling with this macro. I have two sheets; One with a large set of data that is updated by a macro with respect to multiple dates. </p>
  
  <p>I want to copy the data from that sheet ("rawdata1") to another sheet ("sheet1"), but only if the data isn't already present (don't want multiple entries of the same data on "sheet1"). I have no problem copying the data to the other sheet but how do you avoid duplicate entries when the macro is run multiple times?</p>
  
  <p>The code I have so far:</p>
  
  <pre><code>Sub CopyData()
  'Copy data if not present in other sheet
  '???
  
  Sheets("rawdata1").Select
  Range("A4:AC10000").Select
  Range("A4:AC10000").Copy
  
  Sheets("Sheet1").Select
    ' Find the last row of data
    FinalRow = Cells(Rows.Count, 1).End(xlUp).Row
    ActiveSheet.Paste
    Sheets("Sheet1").Select
  </code></pre>
  
  <p>Thanks for the help!</p>