Is it possible to automatically generate a Employee Shift Schedule using VBA?

[sn152]

Hi All,

Is it possible to automatically generate a Employee Shift Schedule using VBA?

I have 3 different shifts (6 AM to 3 PM, 1 PM to 10 PM, 9 PM to 6 AM).

There are 9 employees and it is a 24/7 shift pattern with 2 employees in each shift (that is 6 employees will work on a daily basis and rest 3 employees with be OFF.)

Is this possible using VBA to automatically generate the above mentioned shift pattern?
If any of you could give me a hint on this, I would be really helpful and I would be able to create it.

Thanks in advance!

 

[vletm]

Something like this ...