Simon Lloyd;334344 Wrote:
Just looking at your revised workbook i see the SITE sheet is now dated
in single days yet 7 days across the columns and you no longer are
looking at "Week1", "Week2"...etc, can you tell me what its is you
really want to see and do?
I just did some quick changes, your workbook is now only 3 sheets, the
dropdown data sheet you can hide, on the roster sheet choose an employye
from the dropdown in A2 and then a week form the dropdown in B2 and the
rest of the sheet will populate, your patrols sheet now has 52 weeks on
it and the patrols on the right can be changed by clicking them as there
is more data validation there, i have also split the times up from
21:00:00 - 23:00:00 to seperate columns this makes it easier to
calculate hours worked.

Anyway, after all that this workbook won't give you the data or
flexibility you need, you need to go back to the design stage, for
example, you can only assign one patrol site in any one week for any one
employee!

The workbook should get you started in the right direction when you
disect it and see how its working.


+-------------------------------------------------------------------+
|Filename: Example Employees Roster.xls |
|Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=122|
+-------------------------------------------------------------------+

--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=91647