Results 1 to 13 of 13

Compare Cells in Column A, and add all like rows together

Threaded View

  1. #1
    Registered User
    Join Date
    04-17-2013
    Location
    Walla Walla, Washington
    MS-Off Ver
    Excel 2007
    Posts
    19

    Compare Cells in Column A, and add all like rows together

    Hello! I'm looking for some help with a macro. I have a list of SKUs, and I'd like to be able to run a macro that finds all like SKUs, adds the values in columns C, D, E, F, and G in the first row of the like SKU, and delete the remaining rows. Here is an example.

    Before Macro:

    BlstSGMXAplIph5Blk 0 28 22 0 11
    BlstSGMXAplIph5Blk 6 39 7 0 2
    BlstSGMXAplIph5Blu 0 5 0 0 0
    BlstSGMXAplIph5Blu 0 13 0 0 0

    After Macro:

    BlstSGMXAplIph5Blk 6 67 29 0 13

    BlstSGMXAplIph5Blu 0 18 0 0 0

    Can anyone help me?
    Last edited by TimBZKK; 04-26-2013 at 07:07 PM.

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