Hi All,
I am new to the forum so apologies if this is in the wrong place, at work at the start of the month we receive a list of tasks for the month, this list doesn change during the month and always covers the whole month. I am looking for a way to allocate tasks in an even (or even as possible fashion) between employees. I have attached a sample of the sheet I am currently working with.
A report is run at the beginning of the month which gives me the results in Sheet 1 on attached. I want to be able to copy the information from this report over to a workbook whereby in the statistics sheet I can click allocate and this will allocate an even number of tasks between employees, showing on sheet 1 who the task has been allocated to.
I think I have formulas to cover the rest of the stuff I would need but really could do with a way to allocate an even number of tasks between employees.
I am new to the forum so apologies if this is in the wrong place, at work at the start of the month we receive a list of tasks for the month, this list doesn change during the month and always covers the whole month. I am looking for a way to allocate tasks in an even (or even as possible fashion) between employees. I have attached a sample of the sheet I am currently working with.
A report is run at the beginning of the month which gives me the results in Sheet 1 on attached. I want to be able to copy the information from this report over to a workbook whereby in the statistics sheet I can click allocate and this will allocate an even number of tasks between employees, showing on sheet 1 who the task has been allocated to.
I think I have formulas to cover the rest of the stuff I would need but really could do with a way to allocate an even number of tasks between employees.