Change roster view

[ixa37]

Hi everyone,

i am experiencing a problem and i need help to resolve it. My Manager like to use the calendar format to plan work for night shift. For evenly the work load, he will use the duty roster format to track personnel duty records.

see attach for more information. please advise thanks.

[MarvinP]

Hi ixa,

See if a Pivot Table does what you need. See the second sheet.

[ixa37]

Hi Marvin,

Thanks for your fast reply, but this not the result I am looking for. My manager will use the "Calendar" worksheet to plan the night shift and use the "Duty roster" worksheet to view the workload. i have also explore the function in the pivot table but they are not able to provide me with the solution that I need.

thank you very much.

[fandi_Damore]

I hope this will help you

[ixa37]

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

[fandi_Damore]

Sorry for my miss understand, is it what you're looking for?
please see sheet duty roster, columns A & C for the formula

if this like you're looking for, please mark this thread with solved

[ixa37]

Hi Fandi,

you are a life saver thank you very much