title: Create a table that shows selected rows from another sheet
body: <p>I have an Excel workbook with a sheet looking something like this:</p>
  
  <pre><code>Apple    |    15    |    Bob
  Banana   |    20    |    Tim
  Apple    |    19    |    Mary
  Banana   |    25    |    Kate
  </code></pre>
  
  <p>I want to create another sheet that only shows rows from the first sheet that have "Apple" in the first column:</p>
  
  <pre><code>Apple    |    15    |    Bob
  Apple    |    19    |    Mary
  </code></pre>
  
  <p>In a sense this is analogous to an SQL SELECT query, where we select all entries in the first table (sheet) that have a given value.</p>
  
  <p>The catch is that I don't want to have to constantly maintain the second sheet. If I change the first sheet—for example, change "Apple" in the first row to "Grape"—I want the second sheet to automatically update so that it only shows "Apple" rows—in that example, only the "Mary" row would now be shown.</p>
  
  <p>This would seem to be a commonly useful feature. Is it possible to do this without using Visual Basic scripting?</p>