Change roster view

I hope this will help you

Hi Fandi,

Sorry for the late reply, I was amaze on what you have come out but it is not what I am looking for. What I need is my manager will key in "Night Shift" on the Calendar worksheet, he will use the "Duty Roster" worksheet to monitor who is on duty on the particular day.

Thank you very much