vetjunkie
asked on
VBA to add monthly hours
excel VBA
I need a vba to add monthly hours for each employee. the data is set for each employee in rows for each check. an employee can have up 26 check for the year. we want the output for the employee data to show the sum in one row each month in a column on the same row.
example output
name Jan Feb march April
Mike 120 130 87 119
C--Users-JQuad-Desktop-48-aca-1409.xlsm
I need a vba to add monthly hours for each employee. the data is set for each employee in rows for each check. an employee can have up 26 check for the year. we want the output for the employee data to show the sum in one row each month in a column on the same row.
example output
name Jan Feb march April
Mike 120 130 87 119
C--Users-JQuad-Desktop-48-aca-1409.xlsm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Glad to help. I'm sure there's a way to do with VBA, but this was faster to come up with.
ASKER
Thank you Mike
ASKER