I have a spreadsheet with employee names, jobs, and their work hours per month, as shown below. I pull this data from a large database and I use VBA code get it into this form.
Employees can have one or more jobs and it changes monthly. I would like to be able to sum the hours per month and put the totals on the blank row under the last job listed. Does that make sense? I have stared at this for awhile and just can't figure out a way to do it. I cannot use formulas in the cells. I would need to use VBA code as the sheet gets cleared every month so new data can go on it. Any help would be appreciated. Thanks.
and so on...Name Job Apr May Jun
Bill Job1 10 10 10
Bill
Joe Job1 20 10 20
Joe Job2 10 10 0
Joe Job3 0 5 5
Joe
John Job1 20 10 10
John Job2 10 0 0
John
Employees can have one or more jobs and it changes monthly. I would like to be able to sum the hours per month and put the totals on the blank row under the last job listed. Does that make sense? I have stared at this for awhile and just can't figure out a way to do it. I cannot use formulas in the cells. I would need to use VBA code as the sheet gets cleared every month so new data can go on it. Any help would be appreciated. Thanks.