title: vba specific text copy to another tab
body: <p>Having issues with some vba, if anyone can point me in the right direction it would be greatly appreciated, currently my code is returning a full row of data and it is returning multiple rows, this is my current code.</p>
  
  <pre><code>    Sub BUTTONtest_Click()
  Dim c As Range
  Dim j As Integer
  Dim Source As Worksheet
  Dim Target As Worksheet
  
  ' Change worksheet designations as needed
  Set Source = ActiveWorkbook.Worksheets("Two Years")
  Set Target = ActiveWorkbook.Worksheets("Two Years League")
  
  j = 3     ' Start copying to row 1 in target sheet
  For Each c In Source.Range("G6:K6")   ' Do 50 rows
      If c.Text = "OVER" Then
         Source.Rows(c.Row).Copy Target.Rows(j)
         j = j + 1
      End If
  Next c
  End Sub
  </code></pre>
  
  <p>I need to look at each row and in each row if the word "OVER" appears I need it to return the information in the side bar e.g. column B I would need this to apply for each wee section e.g. Column C- F should return the number from column B and H-K should return G etc.</p>
  
  <p><a href="https://i.stack.imgur.com/VnCaX.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/VnCaX.jpg" alt="enter image description here"></a></p>