title: How to copy part of dynamic tables in excel based on an id?
body: <p>I have 2 dynamics tables in a worksheet</p>
  
  <pre>
      projectId | start    | end      | employee | name | amount
      ----------------------------------------------------------
      5013-001  | 12-01-01 | 13-01-01 |  001     | bob  | 100 $
                                      |  021     | foo  | 200 $
                                      |  101     | bar  | 300 $
                                      |  111     | luc  | 300 $
      ----------------------------------------------------------
      total 5013-001                                      900 $
      ----------------------------------------------------------
      5013-002  | 12-01-01 | 13-01-01 |  001     | bob  | 150 $
                                      |  021     | foo  | 205 $
      ----------------------------------------------------------
      total 5013-002                                      355 $
  
      --Snip--
  </pre>
  
  <pre>
      projectId | expenseCode     | total
      ---------------------------------------
      5013-001   | T01 Summary      | 4504$
                 | D01 Summary      |  204$
      total 5013-001                | 4708$
      ---------------------------------------
      5013-002   | T01 Summary      | 1007$
      total 5013-002                | 1007$
  
      --Snip--
  </pre>
  
  <p>expected result : </p>
  
  <pre>
      projectId | start    | end      | employee | name | amount
      ----------------------------------------------------------
      5013-001  | 12-01-01 | 13-01-01 |  001     | bob  | 100 $
                                      |  021     | foo  | 200 $
                                      |  101     | bar  | 300 $
      ----------------------------------------------------------
      total 5013-001                                      600 $
      ----------------------------------------------------------
  
      projectId | expenseCode     | total
      ---------------------------------------
      5013-001   | T01 Summary      | 4504$
                 | D01 Summary      |  204$
      total 5013-001                | 4708$
      ---------------------------------------
  
      --page break--
  </pre>
  
  <p>How would you proceed to have both tables filtered by projectId, each on one page? (number of columns is fix, but not rows!)</p>
  
  <p>I'm guessing a macro but I though there might something simpler.</p>
  
  <p>If I should indeed use a macro, is the engine powerful enough? I never coded excel macro, so I'll gladly take any tips/references.</p>
  
  <p>One last <em>subjective</em> question : Do you think this problem is solvable in ~1 workday?</p>