I need a code that looks for a match for employee# from "OT Report page"
on the "DownLoad page" and once it finds the match then finds the word
Productive from the a range associated with the cell location of the
match, then get the value of the cell next to the word productive and
put it in the cell under worked of the "Ot Report Page".


--
Teerings3
------------------------------------------------------------------------
Teerings3's Profile: http://www.excelforum.com/member.php...o&userid=29560
View this thread: http://www.excelforum.com/showthread...hreadid=492620