title: Copy cell from on sheet to another, if other cell in row matches values
body: <p>What I want, is to copy a cell(s) from one sheet to another, only if another cell in the same row (different column) have/has a particular value(s) in Google Sheets.</p>
  
  <p>Ideally, I would like this to be live; if I add a row in the first sheet and the criterion matches, the second sheet will update too. Here's an example:</p>
  
  <pre><code>Sheet one
  
  Column A | Column(s)…  | Column D
  =================================
  Hello    |             | Yes
  World!   |             | Yes
  Foo      |             | Maybe
  Bar      |             |
  
  Sheet two
  
  Column A | Column(s)…  | Column D
  =================================
  Hello    |             |
  World!   |             |
  Foo      |             |
           |             |
  </code></pre>
  
  <p>So in this example, my criteria is that if the row's cell in <code>Column D</code> equals either <code>Yes</code> or <code>Maybe</code>, that row's cell in <code>Column A</code> is copied into the second sheet.</p>