Hi all,



I have made a rota system for a nursery that was being done by hand ( I am taking over and can't do it like that, takes too long).

I was trying to enable to system to look at a fortnightly rota and want it to look at the table and put a person in a box if it is the correct day or not.

I have used an if statement to add those that are the same every day but swap depending on if it is week 1 or 2, but other staff's hours are different or might not be in depending on the day.

I was trying to use an if statement to say if week 1/2 then look at the appropriate table and then looking at the week day, select the person for that day and put it in the box?

I was thinking if that is not possible I could easily split and have a seperate file for week 1 and 2 and just focus on getting the page to look at mon-fri and position them in if it is the correct day. That is what I was going to try next but just wanted some support on which route is probably going to be more viable.

page 1 of the file has the table I am presenting the rota on, while page 2 has the tables for staff times and work days, sorted into their appropriate rooms.


thanks all

Attached Files

Copy of Rota file test.xlsx (20.7 KB, 10 views)