title: VBA Excel 2013 Copy certain information from one worksheet to anther worksheet - weekly reports
body: <p>I'm super new to VBA and hope that someone can help. This is what I have so far:</p>
  
  <pre><code>Public Sub Late()
  
      Dim LastRow As Long
      Dim MasterLastRow As Integer
      Dim NewRange As Range
      Dim TrackingCount As Integer
  
  
      Worksheets("Master").Select
      Range("A4").Select
  
      LastRow = Cells(Rows.Count, 1).End(xlUp).Row
      Set NewRange = Cells(LastRow + 1, 1)
      Dim i As Integer
      For i = 1 To LastRow
          If TrackingCount &gt; 14 Then 
             'Copy row, col. A:M of "Master" worksheet into Col. A:M of "Late Report" worksheet
          End If
      Next i
  </code></pre>
  
  <p>Explanation: For each TrackingCount in Col Q of "Master" worksheet that is > 14, I need to copy only these rows, from columns A thru M and paste them into "Late Report" worksheet (beginning with A:3), one row after the other (for each one with TrackingCount > 14).</p>
  
  <p>Once that's accomplished, I need to do the same thing when Tracking count is between 7 &amp; 14 (to paste in the Late Report spreadsheet following the first report); then between 2 &amp; 6 for a third report; and finally when =&lt; 0 for the final report.</p>
  
  <p>All reports need to paste one after the other. This is for a weekly report in which the the row counts will be different each week.</p>