VB Code to combine multiple entries into one
I have a spreadsheet of employee names and hours worked. Each employee has multiple entries for different reasons. I want to combine all the hours for each employee in one row. The hours are in columns B, C, D, and E. Some columns may have more than one entry for each employee. I want to add the numbers in the colums for each employee.
EX:
NAME TRACK HRS TRACK REG PP HRS PP REG
ABRAMS, JAMES 12.82 12.00 0
ABRAMS, JAMES 10
ACKER, EDWARD 12.22 11.50
ACKER, EDWARD 0 10
ADAMS, CLIFTON 13.00 12.50
ADAMS, CLIFTON
ADAMS, JAMES 12.33 11.50
ADAMS, JAMES 0 10
ADAMS, JENNIFER 12.57 11.50
ADAMS, JENNIFER 0 10
ADAMS, JESSIE 0 8
ALBERSON, OWEN 11.35 11.00
ALBERSON, OWEN 0 10
ALBERT, TRAVIS 12.38 11.50
ALBERT, TRAVIS 0 11.5
Linear Mode
