View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.misc
Aussiegirlone Aussiegirlone is offline
external usenet poster
 
Posts: 1
Default which one to use: Macros / Formula's / Lookup


It goes like this.
The roster is made up for the entire day of each employee for the total
week. However if one employee decides not to show up [with only an hours
notice] then the roster has to be change so that someone can replace
that employee as they are all on call at a moments notice.

Your comment: No way to determine the last entry/change

My reply
Once the week has ended all data entered will not be changed for the
week ended however, the week must end with all jobs completed.

If the week has not ended then changes should be able to be made.

As for the times there will be no AM or PM

Also here is the revised Roster. Can you tell me how to delete the
other roster please?:)


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

--
Aussiegirlone
------------------------------------------------------------------------
Aussiegirlone's Profile: http://www.thecodecage.com/forumz/member.php?userid=272
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=91647