Thanks that worked for my model, but the location of the wor
"productive" will vary
with each new download of employee time punches. Plus what ever I us
to get the hours of "pruductive" , I will then use to find PTO for tha
employee or OVERTIME and EIB, and so on..............The only constan
is that after you match employee# that key word will be found befor
the next employee # or the result is "0"

--
Teerings
-----------------------------------------------------------------------
Teerings3's Profile: http://www.excelforum.com/member.php...fo&userid=2956
View this thread: http://www.excelforum.com/showthread.php?threadid=49261