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...