title: Vba macro to copy row from table if value in table meets condition
body: <p>i'm trying to make a macro which:</p>
  
  <ol>
  <li>goes through a table</li>
  <li>looks if value in column B of that table has a certain value</li>
  <li>if it has, copy that row to a range in an other worksheet</li>
  </ol>
  
  <p><strong>The result is similar to filtering the table but I want to avoid hiding any rows</strong></p>
  
  <p>I'm kinda new to vba and don't really know where to start with this, any help much appreciated.</p>