Hi guys,

I have this issue on scheduling. Basically what I have done was to extract data of employees who can work a day (Tues - Sun) and 2 shift per day. Eg Employee 1 works Tues Shift A, Wed Shift B, Sun Shift A.

How can I export the data from this sheet to a scheduling where it automatically links the look up of day then allocate the shift on that day? I have attached my sample in this thread.

Thank you so much!!! Book1.xlsx