title: Excel 2010 VBA: Copying rows, dynamically choosing them based on a value on a certain column
body: <p>Just getting my feet wet with VBA for Excel. Looked around for similar issues and couldn't find anything exactly like this.</p>
  
  <p>Pretty simple issue. I have some data and want to copy a section of the rows to another spot in the sheet. I don't think it'll let me post an image yet, so let's say it looks like this:</p>
  
  <pre><code> Column A     Column B     Column C
   product1        1          #VALUE!
   product2        4            100
   product3        22            25
   product4        0             3
  </code></pre>
  
  <p>The rows I'd want to copy are ones where Column C is 5+. So, rows 3 and 4 in this case. The total number of rows should always be the same, if that helps.</p>
  
  <p>I can do the copying and pasting in VBA, just wondering what the best way to select these rows would be. I tried a Do Loop with x being the column number, checking it was ">4", but I can't get it to work.</p>
  
  <p>Thanks very much! </p>