VBA_Confused
New Member
- Joined
- Aug 27, 2014
- Messages
- 6
Hi all,
After some great help with my first query here, I have another query I hope you can help with!
I have a timesheet style database, each staff member is allocated a row and then for each day they have to choose a description of activity that day 'Sick' 'TOIL' etc. In the column next to the description cell is another for them to enter the hours allocated to that activity.
What I want to be able to do is count the number of hours that each worker allocates to each activity so at the end of each month I can see how much time is being dedicated to certain activities.
So, worker 1 is on Row 6. In G6 they choose 'Sick' from a drop list and in G7 they type 7.5 for the hours. How do I search the whole of row 6 for 'Sick' and then each time it appears count the hours in the column one to the right and then display the total for all time allocated to 'Sick' for Worker one??
After some great help with my first query here, I have another query I hope you can help with!
I have a timesheet style database, each staff member is allocated a row and then for each day they have to choose a description of activity that day 'Sick' 'TOIL' etc. In the column next to the description cell is another for them to enter the hours allocated to that activity.
What I want to be able to do is count the number of hours that each worker allocates to each activity so at the end of each month I can see how much time is being dedicated to certain activities.
So, worker 1 is on Row 6. In G6 they choose 'Sick' from a drop list and in G7 they type 7.5 for the hours. How do I search the whole of row 6 for 'Sick' and then each time it appears count the hours in the column one to the right and then display the total for all time allocated to 'Sick' for Worker one??