title: VBA Excel filter data and copy to another worksheet - Newbie alert
body: <p>Hi I am a complete newbie when it comes to VBA Excel.</p>
  
  <p>Im trying to filter a variable sized spreadsheet full of data looking for a set word in one column. Once found I want to copy the complete row to another worksheet.</p>
  
  <p>As they maybe more than one row with this word in it I don't want to write over the previous copied row.</p>
  
  <p>this is what ive created to find the word, but how do I copy the row to another worksheet?</p>
  
  <pre><code>Sheets("Sheet1").Select                                 'Select datasheet
  Range("A1").Select                                      'Set cell position to start search from
  
  Do Until Selection.Offset(0, 4).Value = ""              'word to be searched is 4 cell in
                                                          'do what is required
      If Selection.Offset(0, 4).Value = "UKS" Then
          MsgBox "Found"                                  'Found it!
          'not sure how to copy row to another worksheet
      End If
  
  'finish move on to next one in list
           Selection.Offset(1, 0).Select                  'move down 1 row
      Loop
  
      Range("A1").Select ' reset cell position
  </code></pre>
  
  <p>Any help would be appreciated, please could you explain how it works as well as I like to understand rather than just copying.</p>
  
  <p>Jason</p>