Results 1 to 8 of 8

Consolidate row data based on 2 criteria and summing one column.

Threaded View

  1. #1
    Registered User
    Join Date
    03-25-2013
    Location
    Delaware, OH
    MS-Off Ver
    Office 2019/Office 365
    Posts
    65

    Consolidate row data based on 2 criteria and summing one column.

    I am fairly new to VBA and not sure how to handle this. I have a sheet with 11 columns of data. Column A is Employee ID, Column B is Pay Code and Column D is Hours worked. There are some rows that have the same Employee ID and Pay Code and I would like to combine these and add together Hours. Anything you can do to help is appreciated. I have attached a sample sheet. Thank You.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 6
    Last Post: 12-13-2016, 03:06 PM
  2. [SOLVED] Consolidate data in 2 rows into 1 row, based on column criteria
    By PeS in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-22-2012, 11:41 AM
  3. Summing Values in column based upon multiple criteria
    By shantanuk in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-21-2012, 09:29 AM
  4. Replies: 3
    Last Post: 09-27-2011, 01:37 PM
  5. Replies: 9
    Last Post: 06-29-2009, 01:14 AM
  6. Summing rows based on criteria in another column
    By reybie in forum Excel General
    Replies: 2
    Last Post: 07-11-2006, 02:15 PM
  7. [SOLVED] Counting & Summing based on criteria on another column
    By Chicago D in forum Excel General
    Replies: 2
    Last Post: 08-25-2005, 02:05 PM

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