Merge Duplicates then Sum and Count values

  • I often need to merge multiple occurences of data (tax addresses & tax names) and to sum or count the values associated with each invividual instance (i.e number of units per tax address). Data can often be thousands of rows and varies every time. I would like to keep all of the associated information with each entry for mailing purposes. I saw this link...
    http://www.ozgrid.com/forum/showthread.php?t=83101


    However, the VBA macro, when run, only keeps my tax address an the associated sum. Please let me know if there is a way to alter the code to make this possible. I will attach the file I am working with.

  • Re: Merge Duplicates then Sum and Count values


    awilkins,


    Welcom to Ozgrid.


    Please take the time to read the rules regarding thread titles and, in future posts, do not use phrases/words like "Please Help". Your thread title should accurately reflect your question or need and not assume a solution.
    Thread titles are used to return relevant search results, so think "search friendly" when developing the title.


    Thanks,


    AAE

  • Re: Merge Duplicates then Sum and Count values


    Next code could help for the active sheet

    Files

    • copy2.xls

      (195.58 kB, downloaded 13 times, last: )

    Triumph without peril brings no glory: Just try