Macro for Task Allocation to Employees

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:
I have a set of tasks (Task 1 to Task 10)
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

I need the macro to loop these tasks and assign John, Ken or Kyle.

Final output will be similar to this:
Task 1 John
Task 2 John
Task 3 John
Task 4 John
Task 5 John
Task 6 John
Task 7 John
Task 8 Ken
Task 9 Ken
Task 10 Kyle

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.