Hi all!
I have a slight problem I've been trying to work on for a while.
I currently have two excel tabs one with day plans and one with a master rota.
The master rota has a list of people and the hours they work for the week.
It's laid out like
Master rota
Name Monday Tuesday Fred John 8:00 17:00 9:00 17:00
The second tab has something called a day plan which has another table.
What I need in the table is the persons name who's in for that day and the hours they are working.
Day plan
Name Start time End time Lunch (Empty field) Fred John 8:00 17:00
So I've done a VLookup in both the Start time & End time which will read the name from the Name field and then add the start time and the end time.
What I want is the the Name field to be automatically filled in for each different day in the day plan.
I'm not explaining this well but if there is an empty field in the start time or end time on the Main rota then I don't want there name in the Dayplan for that day.
Example: John is working Monday 8:00 - 17:00 but isn't working Tuesday but is working wednesday 8:00 - 17:00 Therefore his name should appear on the dayplan for Monday & Wednesday but Not for Tuesday.
I hope I explained that well enough... I know I need somesort of IF command but I just can't figure it out.
Thanks!
Bookmarks