Creating a staff roster in Excel

[Minkus26]

I am trying to create a staff roster for 43 staff to do four 2 hour shifts per day. Five people per shift.

I want excel to allocate staff automatically from an available staff list. Is this possible if so can you advise a text book or manual to teach me how to do this.

Thanks

Teresa

 

[dr_shivan]

Welcome to the board Teresa,

How do you want to automatically allocate staff? Randomly?
Can 2 person work in the same shift for different weeks?

 

[Minkus26]

I want staff to be allocated randomly, 5 people per shift, 4 shifts of 2 hours per day, Monday to Saturday.

Thanks