VBA Logic to loop through a set of tasks and assign employees equal no of task

[rishita123]

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 remains same but no of cases and no employees changes everyday.
Attaching file for reference. Please check sheet 1 and sheet 2


I would be grateful to anyone who can help me with this logic.

Thanks in advance,
Regards,
Rishita

▬▬▬▬▬▬▬▬▬ Mod edit : thread closed as duplicate !

​