title: Use SQL-style query in Excel using VBA
body: <p>I have a large excel sheet which looks similar to this:</p>
  
  <pre><code>date       |  name  |  age  |  type
  10/10/2012 | James  |  12   |  man 
  11/10/2012 | Jane   |  50   |  woman 
  12/10/2012 | Freddy |  2    |  dog
  13/10/2012 | Bob    |  23   |  man
  14/10/2012 | Mary   |  34   |  woman 
  </code></pre>
  
  <p>What I want to do is create a new, dynamically generated table showing all the men.</p>
  
  <p>In SQL this would be a synch: <code>"SELECT * FROM table WHERE type='men'"</code>. I've never used VBA in excel before (tho I am an experienced PHP/Javascript programmer and have used VBA in MS Access) so I'm looking for beginners instructions to get me started. Perhaps someone can recommend a simple tutorial or blog post that does something like what I need to do?</p>