I've created a spreadsheet that itemizes employee payroll and class codes. I would like to compile the total payroll for each class code on a separate worksheet. For ex:
sheet 1
EMPLOYEE CODE PAYROLL
DAVIS, LOREEN 9107 $41,000
FISHER, JOHN 8047 $66,000
JONES, DIANE 8810 $32,000
RYAN, GARY 9107 $28,000
SMITH, JOE 8810 $27,000
WOODS, KAREN 8047 $52,000
sheet 2
CODE PAYROLL
8810 $59,000
9107 $69,000
8047 $118,000
I know how to reference another worksheet, but not sure how to compile all payroll from a unique class code into a separate line of data.
Any ideas?
Thank you,
Heather
Bookmarks