title: Querying and adding date between structured tables in Excel
body: <p>All,</p>
  <p>I might be asking a question that has been answered before, so please let me know if this is the case.</p>
  <p>For my Families Business i am setting up an excel administration.
  the case at hand is,</p>
  <p>WE have a structured Excel table containing a list of clients. Some of these clients will have to be invoiced  individually and others are are invoiced though an organisation.
  In my strucutred table these that have to be invoiced individually are makered (simple &quot;YES&quot; in column). Now i want to extract those clients whith the &quot;Yes&quot; into a new structured table and add invoicing details to that new 2nd table.</p>
  <p>Any suggestions on how to do this.
  Reason i do not want to have this in the 1st table is not all clients neeed individual invoicing and the first table becomes too big to interpret in one go.</p>
  <p>Thanks for helping me.</p>
  <p>Below the master Table</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>name</th>
  <th>Private (yes/No)</th>
  <th>email</th>
  <th>Date of Birth</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>Name A</td>
  <td>Yes</td>
  <td>some@mail.com</td>
  <td>1-2-2344</td>
  </tr>
  <tr>
  <td>Name B</td>
  <td>No</td>
  <td>some@othermail.com</td>
  <td>1-2-3456</td>
  </tr>
  <tr>
  <td>Name C</td>
  <td>Yes</td>
  <td>some@othermail2.com</td>
  <td>6-5-4321</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>The result will be a new table [2]</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Name</th>
  <th>Invoicing details</th>
  <th>amount</th>
  <th>Other information</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>Name A</td>
  <td>details for invoicing</td>
  <td>100</td>
  <td>Ipsum</td>
  </tr>
  <tr>
  <td>Name C</td>
  <td>details for invoicing</td>
  <td>50</td>
  <td>Ipsum</td>
  </tr>
  <tr>
  <td>Name etc</td>
  <td>details for invoicing</td>
  <td>200</td>
  <td>Ipsum</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Whereby the data in column &quot;Name&quot; is populated automatically and the other Data is entered by hand</p>