rishita123
New Member
Hi All,
I have an issue developing a VBA program for a small logic.
I need help with a small VBA logic that can loop through a set of tasks and assign Employees to the tasks.
Process:
I have a set of tasks (Task 1 to Task10)( changes daily)
I have n no of employees present( no of employees present changes daily). Everyday I allocate same no of tasks to each employee For e.g
5 employees present today and we have 20 task today
so each employee needs to do 4 tasks
I need the macro to loop these tasks and assign to employees
Final output will be similar to this:
task 1 employee 1
task 2 employee 1
task 3 employee 2
task 4 employee 2
task 5 employee 3
task 6 employee 3
task 7 employee 4
task 8 employee 4
task 9 employee 5
task 10 employee 5
The challenge I have is that the % of allocation changes everyday and occasional an additional employee(s) added.
I would be grateful to anyone who can help me with this logic.
Thanks in advance,
Regards,
Rishita
I have an issue developing a VBA program for a small logic.
I need help with a small VBA logic that can loop through a set of tasks and assign Employees to the tasks.
Process:
I have a set of tasks (Task 1 to Task10)( changes daily)
I have n no of employees present( no of employees present changes daily). Everyday I allocate same no of tasks to each employee For e.g
5 employees present today and we have 20 task today
so each employee needs to do 4 tasks
I need the macro to loop these tasks and assign to employees
Final output will be similar to this:
task 1 employee 1
task 2 employee 1
task 3 employee 2
task 4 employee 2
task 5 employee 3
task 6 employee 3
task 7 employee 4
task 8 employee 4
task 9 employee 5
task 10 employee 5
The challenge I have is that the % of allocation changes everyday and occasional an additional employee(s) added.
I would be grateful to anyone who can help me with this logic.
Thanks in advance,
Regards,
Rishita