One workbook simply lists the days of the week with a column for the names.
if both the sheets were in one workbook, then you could uses a simple
VLOOKUP() formula in the Weekly.xls sheet. However, the daily xls would need
modifying unless the hours worked by an individual is the same for each
day...unlikely


--
Patrick Molloy
Microsoft Excel MVP
---------------------------------
I Feel Great!
---------------------------------
"sparky3883 " wrote in message
...
Thanks again for looking.

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

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

When the information is generated onto the daily rota, the names of the
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 would
appreciate any help.

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

Many many thanks again

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