Hi All,
So this is my most complicated request to date and I just don't know where to start.
I have a new staff rota I would like to view in different ways. In the attachment, you see I have a "People" tab.
On here, I want to see the duties that a particular person is doing on every day of the week, for each hour of that day.
The duties are pulled in from other tabs (each day has a different tab)
The bit that really gets me, is that the daily rota (for example Monday), will show 2 peoples initials on a certain hour. In my example, I have E and R showing on Monday at 8am.
On the people tab, if I pull the persons name in with the initial E, I need to see the duties she's doing.
I have highlighted the important cells in the 3 tabs and very much hoping someone will be kind enough to help me!
Many thanks in advance!
Bookmarks