timeline and rotation with vba

erdem_ustun

New Member
Joined
Jun 19, 2018
Messages
12
Hello there ,

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

There are 6 employees.
Name of Employees
Emp1
Emp2
Emp3
Emp4
Emp5
Emp6

<tbody>
</tbody>

There are 3 locations.


Locations
Loc1
Loc2
Loc3

<tbody>
</tbody>

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
 
Last edited:

Some videos you may like

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Watch MrExcel Video

Forum statistics

Threads
1,109,204
Messages
5,527,396
Members
409,759
Latest member
KCH

This Week's Hot Topics

Top