koli99
06-11-2014, 11:41 PM
Hi!
I'm new to this forum and I'm looking for some help. I'm not a programmer, but I'm trying to make an excel document for following workers activities.
I have a base of workers which log each day their activities in hours (D01-D11). I would like a macro to sum total hours of each project (project numbers are from 320-516) and put it into the table on the left.
For example: For PERSON 1, I want that the cell I60 writes 10, and cell I74 = 6. For worker 2 (PERSON 2) would be AK60 = 3,5; AK67 = 8 and AK74 = 8.
In total where would have been 10 workers.
Is it possible to program this?
Thanks for help!
Regards,
Jure
11809
I'm new to this forum and I'm looking for some help. I'm not a programmer, but I'm trying to make an excel document for following workers activities.
I have a base of workers which log each day their activities in hours (D01-D11). I would like a macro to sum total hours of each project (project numbers are from 320-516) and put it into the table on the left.
For example: For PERSON 1, I want that the cell I60 writes 10, and cell I74 = 6. For worker 2 (PERSON 2) would be AK60 = 3,5; AK67 = 8 and AK74 = 8.
In total where would have been 10 workers.
Is it possible to program this?
Thanks for help!
Regards,
Jure
11809