Pheonix2332
New Member
- Joined
- Feb 3, 2021
- Messages
- 20
- Office Version
- 2013
- Platform
- Windows
Evening all struggling to sleep as have this on my mind for work,
I have collated the weeks work from a different sheet into a new work book and organised it per member of staff, and now assigned a random number against it , however now I need to have an adjustable number of cases per member of staff to be produced into a separate list
An example being ( on phone so apologies for no screen shots)
Agent 1 has 3 cases out of 15 to be reviewed and the same for agent 2 to agent 30. And would need it to be able to change pending performance of the team so if doing well can be reduced to 2 and if performance drops increase it to 5 - can anybody advise how I could go about this please ?
I have collated the weeks work from a different sheet into a new work book and organised it per member of staff, and now assigned a random number against it , however now I need to have an adjustable number of cases per member of staff to be produced into a separate list
An example being ( on phone so apologies for no screen shots)
Agent 1 has 3 cases out of 15 to be reviewed and the same for agent 2 to agent 30. And would need it to be able to change pending performance of the team so if doing well can be reduced to 2 and if performance drops increase it to 5 - can anybody advise how I could go about this please ?