+ Reply to Thread
Results 1 to 4 of 4

VBA helps needed to Sum duplicate values and delete duplicate rows

  1. #1
    Forum Contributor
    Join Date
    10-30-2011
    Location
    Doha
    MS-Off Ver
    MS office 365
    Posts
    701

    Question VBA helps needed to Sum duplicate values and delete duplicate rows

    Hi Folks,

    I have two sheets in my Workbook, one for user input “SAP_INPUT” second one for the summary report. I need a Macro to do the sum of the duplicate row records, delete duplicated rows and do some calculation.

    My small example workbook can describe better.

    Thanks in advance for your expertise!

    Joshi
    Attached Files Attached Files
    Cheers,

    Joshi
    Being with a winner makes you a winner

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: VBA helps needed to Sum duplicate values and delete duplicate rows

    try
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    10-30-2011
    Location
    Doha
    MS-Off Ver
    MS office 365
    Posts
    701

    Re: VBA helps needed to Sum duplicate values and delete duplicate rows

    Hi Jindon,
    Thank you so much, your code working like charm. I need so two more addition on that, now I have to split the "CONCERN" and "NO CONCERN" into two separate sheets (if the sheets are existing, then delete and create new sheets) and the last column formula to be replaced with values.

    Thanks in advance for your time.

    Thanks,
    Joshi

  4. #4
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: VBA helps needed to Sum duplicate values and delete duplicate rows

    I don't like the way you ask question.

    Ask everything in the first place.

    Need to see your desired result.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1