Hi all, hope you can help me with this problem.
I am looking to create a daily department rota off of data from a weekly shift rota. I have included an example on file and it probably explains better in there than I will be on this post.
I have created a Validation list to show staff shifts for a particular day which is the source for that one. And what i'm looking to do is create an adjacent list which will automatically show me who is on that particular shift on a said day.
So for example, I select 9am-6pm on the shift list and the adjacent list will automatically let me choose from everyone who is on that shift on that day.
Any help in this would be greatly appreciated as I am well and truly stuck.
Thank you in advance.