title: How to compare two (pivot) tables data on (different) worksheets?
body: <p>There are 2 worksheets in 1 excel file with the following identical column structure:</p>
  
  <pre><code>BuildIndex | Phase | Module | Duration
  </code></pre>
  
  <p>The column <code>BuildIndex</code> is used as <em>primary key</em>.</p>
  
  <p>Assume the following example data:</p>
  
  <p><strong>Worksheet 1:</strong></p>
  
  <pre><code>1 | Phase 1 | Module 1 | 5
  1 | Phase 2 | Module 1 | 3
  1 | Phase 3 | Module 1 | 10
  1 | Phase 1 | Module 2 | 6
  1 | Phase 2 | Module 2 | 2
  1 | Phase 3 | Module 2 | 5
  </code></pre>
  
  <p><strong>Worksheet 2:</strong></p>
  
  <pre><code>2 | Phase 1 | Module 1 | 3
  2 | Phase 2 | Module 1 | 7
  2 | Phase 3 | Module 1 | 9
  2 | Phase 1 | Module 2 | 2
  2 | Phase 2 | Module 2 | 10
  2 | Phase 3 | Module 2 | 4
  </code></pre>
  
  <p>For now I create different pivot tables and diagrams and analyze the differences "by hand" to make decisions like</p>
  
  <ul>
  <li>for <em>build index 1</em> the <em>module 2</em> is build X seconds faster than in <em>build index 2</em></li>
  <li>for <em>build index 2</em> the <em>phase 3</em> (sum of all modules) is build Y seconds faster than in <em>build index 1</em></li>
  </ul>
  
  <p><strong>That's what I want to do:</strong></p>
  
  <p>Because there are many phases and the count of modules is increasing continuously, the above procedure takes too much time and I think there's an automatic way to perform analyzes like these.</p>
  
  <p>So, do you have any idea if there's a way to realize my intention? Feel free to provide hints for excel formulas or pivot tables or vba or or or :-)</p>