title: Sum Column B based on Column A using Excel VBA Macro
body: <p>OK,  I have a simple problem that I need help with in a VBA Macro.  I have an excel sheet that looks like this...</p>
  
  <pre><code>Product #     Count
  101              1
  102              1
  101              2
  102              2
  107              7
  101              4
  101              4
  189              9
  </code></pre>
  
  <p>I need a macro that adds up the "count" column based on the Product Number Column.  I want it to over all look like this after I am done...</p>
  
  <pre><code>Product #    Count
  101              7
  102              7
  107              7
  189              9
  </code></pre>
  
  <p>I am an amiture to VBA so I would love any help I can get.</p>