Thanks again for looking.

In Column C i will lists every member of staff that work for me. I
Columns D to J (Sun to Sat) i will enter the shifts that the member o
staff will be working. (these shifts will vary on a weekly basis an
each member of staff will only work 5 of the 7 days, and again, thes
days will vary)

Once i have given all my staff their shifts for the week, i am hopin
to somehow generate a daily rota for each day of the week, which wil
only show me the names of the staff who are working on that particula
day and the shifts that they are working.

When the information is generated onto the daily rota, the names of th
staff will go in Column A and their shift time will go into Column B.

I do realise that this could be a big tasks, but i really woul
appreciate any help.

I have enclosed a copy of my weekly rota and my daily rota if tha
helps

Many many thanks agai

Attachment filename: weekly.zip
Download attachment: http://www.excelforum.com/attachment.php?postid=50710
--
Message posted from http://www.ExcelForum.com