There are three sheets. Customer Service Roster, Customer Service
Timesheet and Master Data.


Sheet *"Customer Service Roster" *
It is split into five sections, one for each day (Mon-Fri). You click
on a cell under the date and it brings up a list to select. Once you
select the option, the start time appears on the left of it. Pretty
simple.

A5=IF(ISNA((VLOOKUP(B5,'Master
Data'!J79:L106,3,0))),0,(VLOOKUP(B5,'Master Data'!J79:L106,3,0)))

B5=Validation List


Sheet *"Customer Service Timesheet"*
This has the employees listed on A6:A20. Then it has to the right the
dates, with start time, finish time and total hours worked. Once you
select the employee on Customer Service Roster, it should update the
time started on the Timesheet as well.

C7=IF(ISNA((VLOOKUP(A7,'Customer Service
Roster'!A45:B56,1,0))),0,(VLOOKUP(A7,'Customer Service
Roster'!A45:B56,1,0)))



BUT!

It's doing it's job on the Roster, however the data is not transferring
to the Timesheet. I have attached it for your reviews, and assistance.
There are multiple areas that have cond format on them, as well as
hidden, however you should be able to see what I'm trying to
accomplish. Any help is appreciated, and is urgently needed!




+-------------------------------------------------------------------+
|Filename: ROSTER SHEET.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4079 |
+-------------------------------------------------------------------+

--
Shadez
------------------------------------------------------------------------
Shadez's Profile: http://www.excelforum.com/member.php...fo&userid=3481
View this thread: http://www.excelforum.com/showthread...hreadid=488959