title: Excel merging and combining like cells
body: <p>I have a simple excel spreadsheet that is a daily updated list of counters. The format of the sheet is as follows:</p>
  
  <pre><code>A         B          C             D          E
  date      name       computer      info       counter
  </code></pre>
  
  <p>Example:</p>
  
  <pre><code>A             B          C         D              E
  04/04/2012    John       186       Workstation    4813
  04/04/2012    Mary       181       Workstation    2273
  04/05/2012    John       186       Workstation    4822
  04/05/2012    Mary       181       Workstation    2274
  04/06/2012    John       186       Workstation    4854
  04/06/2012    Mary       181       Workstation    2275
  04/06/2012    Bill       183       Workstation    3698
  </code></pre>
  
  <p>and son on....</p>
  
  <p>What I need to be able to do is combine all like cells. So for instance combine all of the rows for each month and subtract the last E column from the first one so it it would look like the following in a new sheet.</p>
  
  <pre><code>A             B          C         D              E
  April 2012    John       186       Workstation    41
  April 2012    Mary       181       Workstation    2
  April 2012    Bill       183       Workstation    0
  </code></pre>
  
  <p>and so on for each one...keeping in mind this is updated daily and have many days, months and years.</p>
  
  <p>I have no idea how to even think about doing this but I assume I would need a macro. If anyone has any assistance that would be great!</p>