title: VBA duplicate issue
body: <p>I am really stucked and I do not know how to make it possible regarding coding in VBA or any coding language. I have to do something for my workplace. I have list in the Column A in my excel sheet. I have different values in it but sometimes I have the same value in different cells in the same column. I cannot remove the duplicates because those same values are a contract-id. In the 9th column I have the total sum of the value of the contract. So it is about automatization of invoices with the help of vba. </p>
  
  <p>I need to add the same values together with the total sum into a different sheet. </p>
  
  <p>Let's say it looks that:</p>
  
  <pre><code>omni345              54€
  omni334              2€
  omni345              23€
  </code></pre>
  
  <p>I need to put the omni345's into one single invoice pdf. I do not know how to put them together. Furthermore I need to place those 2 same values in the invoice like this which is in a different sheet:</p>
  
  <pre><code>omni345     54€
  omni345     23€
  </code></pre>
  
  <p>So that the client clearly can see that there are x different contracts.</p>
  
  <p>What I need is the right direction how to start it. </p>