title: Copying Filtered Data From One Sheet to Another
body: <p>I am attempting to copy filtered data from one sheet to another. It copies everything to the same line. </p>
  
  <p>How do populates all the rows instead of copying them over the same one? </p>
  
  <p>Here is the code I modified:</p>
  
  <pre><code>Private Sub Workbook_Open()
      Dim i, LastRow
  
      LastRow = Sheets("Scheduled WO's").Range("A" &amp; Rows.Count).End(xlUp).Row
      Sheets("Branden").Range("A2:Q10000").ClearContents
  
      For i = 2 To LastRow
          If Sheets("Scheduled WO's").Cells(i, "G").Value = "Branden" Then
              Sheets("Scheduled WO's").Cells(i, "G").EntireRow.Copy Destination:=Sheets("Branden").Range("A" &amp; Rows.Count).End(xlUp).Offset(1)
          End If
      Next
  End Sub
  </code></pre>