View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Benjamin Benjamin is offline
external usenet poster
 
Posts: 102
Default Macro - find dups & add

I have a worksheet with columns Part and Qty. Some Parts have multiple
entries. I need a macro to find the multiple entires and sum the Qty,
creating only one entry per Part. This data will then pass through a macro
being copied and pasted into another table.
Any help?