I have a workbook with a number of staff member tabs the same as the sample workbook attached. On each staff members worksheet the worker enters the clients name and a numeral 1 into either one of four conditions as per the sample workbook.
The workbook is already set up so that when a staff member has finalised their work with a client they enter a numeral 1 into the Closed column. Once they do this the line is copied from this worksheet into the closed worksheet on the next available row and the row is deleted from their own worksheet (in other words the row is deleted from their worksheet and placed onto the next available row of the closed worksheet). This way the staff members only have the active clients that they are working with on their own worksheet and all the closed client are on the closed worksheet.
What I needs some assistance to do is compile the numbers for the report page. The code needs to count the number of numeral 1’s that are entered into each of the four condition columns from row 4 to maybe row 500 and then place the number into the cell on the report page next to the workers name. So there will be so many clients that are condition 1, so many condition 2 and so on. This is the easy part, CountA handles this fine. What needs to be added to these numbers is the numbers from the closed page.
The number of condition 1 that belong to staff member Tom
The number of condition 2 that belong to staff member Tom
The number of condition 3 that belong to staff member Tom
The number of condition 4 that belong to staff member Tom
Also
The number of condition 1 that belong to staff member Jerry
The number of condition 2 that belong to staff member Jerry
The number of condition 3 that belong to staff member Jerry
The number of condition 4 that belong to staff member Jerry
Also
The number of condition 1 that belong to staff member Mickey
The number of condition 2 that belong to staff member Mickey
The number of condition 3 that belong to staff member Mickey
The number of condition 4 that belong to staff member Mickey
And then
The number of condition 1 that belong to staff member Minnie
The number of condition 2 that belong to staff member Minnie
The number of condition 3 that belong to staff member Minnie
The number of condition 4 that belong to staff member Minnie
I hope this makes sense and thank you in advance.
Bookmarks