title: EXCEL VBA - Populating last Row with database new data only
body: <p>So i have a database that i update it daily and i want to populate a sheet with only the tickets that had been breached.
  What i want to do is to check on the database and copy only the new tickets to that sheet right after the last value.</p>
  
  <p>My code now is copying all the tickets avaiable and i wanted to change that.</p>
  
  <p>Can anyone help? Thank you</p>
  
  <p>Here is my code so far</p>
  
  <pre><code>'SELECT DATABASE SHEET
  Sheets("RAW ALL INC").Select
  
  'FILTER ONLY THE BROKEN TICKETS
  Selection.AutoFilter
  ActiveSheet.Range("$A$1:$X$1312").AutoFilter Field:=4, Criteria1:="TRUE"
  
  'COPY ALL TICKETS (THIS IS WHERE I WANT TO SELECT ONLY NEW TICKETS)
  Range("A2").Select
  Range(Selection, Selection.End(xlDown)).Select
  Selection.Copy
  
  'PASTE THE TICKETS ON THE BROKEN TICKETS SHEET
  Sheets("Broken Justification").Select
  Range("A2").Select
  Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
      :=False, Transpose:=False           
  </code></pre>