koala
08-13-2015, 02:40 AM
Hi Forum,
This is not a VBA problem, but maybe some sort of VBA looping and analysing marco will help solve it.
I have a weekly roster, with 6 tasks and 2 worker on each task (ie 12 workers) I have included my spreadsheet to show how it works.
I want the tasks to be set in such a way that each week every worker works with a different worker than previously worked with.
The tasks remain static in the roster location, but each week the workers move down one task
By the time they rotate through the entire roster (12 weeks) they will have worked with every other worker once. (they will always need to work with one worker twice because they cant work with themselves.)
I have achieved this with my old 10 worker roster (5 tasks) but am not able to work it out for the 12 worker (6 tasks) roster (the 10 worker roster is included to show how the result needs to be.)
The tasks can be in any order however preferably not consecutive
Is anyone able to assist?
This is not a VBA problem, but maybe some sort of VBA looping and analysing marco will help solve it.
I have a weekly roster, with 6 tasks and 2 worker on each task (ie 12 workers) I have included my spreadsheet to show how it works.
I want the tasks to be set in such a way that each week every worker works with a different worker than previously worked with.
The tasks remain static in the roster location, but each week the workers move down one task
By the time they rotate through the entire roster (12 weeks) they will have worked with every other worker once. (they will always need to work with one worker twice because they cant work with themselves.)
I have achieved this with my old 10 worker roster (5 tasks) but am not able to work it out for the 12 worker (6 tasks) roster (the 10 worker roster is included to show how the result needs to be.)
The tasks can be in any order however preferably not consecutive
Is anyone able to assist?