timeline and rotation with vba

[erdem_ustun]

Hello there ,

I have a rotation problem at the workplace where I work.
I'd appreciate it if you run.

There are 6 employees.
[TABLE="width: 500"]
<tbody>[TR]
[TD]Name of Employees[/TD]
[/TR]
[TR]
[TD]Emp1[/TD]
[/TR]
[TR]
[TD]Emp2[/TD]
[/TR]
[TR]
[TD]Emp3[/TD]
[/TR]
[TR]
[TD]Emp4[/TD]
[/TR]
[TR]
[TD]Emp5[/TD]
[/TR]
[TR]
[TD]Emp6[/TD]
[/TR]
</tbody>[/TABLE]

There are 3 locations.


[TABLE="width: 200"]
<tbody>[TR]
[TD]Locations[/TD]
[/TR]
[TR]
[TD]Loc1[/TD]
[/TR]
[TR]
[TD]Loc2[/TD]
[/TR]
[TR]
[TD]Loc3[/TD]
[/TR]
</tbody>[/TABLE]

Creates a team of 2 employees

A team(2 employees) will work together at each location with rotation.

Employees will rotate within themselves


Any employee other than himself will be teamed up with the order of 5 other people.


At the same time, this team will also be rotating at the work places.


Every day, teams and work places will change every day except weekends.


How can I make the time schedule of employees and locations on a monthly basis.


Every employee has worked with everyone and everywhere at an equal rate.


I create employees and locations with permutations with vba , but I don't know how to assign them on the calendar.


with all respect