title: Vba: Select Multiple rows based on Text
body: <p>I have a list made up of 4 columns and undetermined rows. I am trying to collect only Col B and C where Col B has words Jackpot and copy them in order to a new sheet. I have gotten the list to sort, but using UsedRange, copies all the rows. How do I only copy over B and C?</p>
  
  <pre><code>Range("A1").Activate
  ActiveCell.EntireRow.Insert
  Rows("1:1").Select
  Selection.AutoFilter
  Selection.AutoFilter Field:=2, Criteria1:="Jackpot"
  
  ActiveSheet.UsedRange.Select
  </code></pre>
  
  <hr>
  
  <pre><code>Col A | Col B |      Col C | Col D
  1       Stuff          1       1
  1       MoreStuff      2       1
  1       Jackpot        3       1
  1       Jackpot        4       1
  1       SomeStuff      5       1
  1       Jackpot        6       1
  </code></pre>