VBA Logic to loop through a set of tasks and assign Employees

[rksample]

Hi Excel Gurus,

I need help with a small VBA logic that can loop through a set of tasks and assign Employees to the tasks.

Process:

1. I have a set of tasks (Task 1 to Task 10)
2. I have 3 Employees (John, Ken and Kyle). Everyday I allocate different % of tasks for each employee based on their work load. For e.g
   • John - 70% of tasks
   • Ken - 15% of tasks
   • Kyle - 15% of tasks
3. I need the macro to loop these tasks and assign John, Ken or Kyle.

Final output will be similar to this:
[TABLE="class: grid, width: 200"]
<tbody>[TR]
[TD]Task 1[/TD]
[TD]John[/TD]
[/TR]
[TR]
[TD]Task 2[/TD]
[TD]John[/TD]
[/TR]
[TR]
[TD]Task 3[/TD]
[TD]John[/TD]
[/TR]
[TR]
[TD]Task 4[/TD]
[TD]John[/TD]
[/TR]
[TR]
[TD]Task 5[/TD]
[TD]John[/TD]
[/TR]
[TR]
[TD]Task 6[/TD]
[TD]John[/TD]
[/TR]
[TR]
[TD]Task 7[/TD]
[TD]John[/TD]
[/TR]
[TR]
[TD]Task 8[/TD]
[TD]Ken[/TD]
[/TR]
[TR]
[TD]Task 9[/TD]
[TD]Ken[/TD]
[/TR]
[TR]
[TD]Task 10[/TD]
[TD]Kyle[/TD]
[/TR]
</tbody>[/TABLE]

The challenge I have is that the % of allocation changes everyday.

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

Thanks in advance,

cheers,
Ravi.
[TABLE="width: 132"]
<tbody>[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[liiamra]

Hi,

Why challenge? Use accumulation!

Even if you use %'s such as 52.3%, you can still use the Round() function.

Regards//