title: VBA code to add duplicates and remove
body: <p>I am really stuck on a code for this form.
  I want to create a command button that will allow the user to simplify the report and combine all like items and remove the duplicates. This will be used a Purchase request. I've attached a photo of the form here ->
  <a href="https://i.stack.imgur.com/mTse5.png" rel="nofollow noreferrer">Form</a></p>
  
  <p><a href="https://i.stack.imgur.com/Y1GEr.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Y1GEr.png" alt="enter image description here"></a></p>
  
  <p>I need the button to find duplicates in column C and sum the totals from column F and then remove duplicates leaving the original behind with a grand total in the QTY menu. Is that possible and still keep it on the same sheet or would it be better to have it duplicate to a new sheet?</p>