title: Excel expression to copy rows but remove blank rows
body: <p>I need to copy data from one worksheet into another.  However, I need a conditional copy operation that will skip rows based on criteria.</p>
  
  <p>For example, if I start with...</p>
  
  <pre><code>Active  Value
  yes     1
  no      2
  no      3
  yes     4
  no      5
  no      6
  </code></pre>
  
  <p>I only want to copy rows that are Active=yes, so I would end up with...</p>
  
  <pre><code>Value
  1
  4
  </code></pre>
  
  <p>Can someone show me how this is done with 1) a macro and 2) a formula?</p>