Hello Anice

I achieve the same thing by using a VLOOKUP formula linking the
workbooks by using the employee number as a primary key in column A.

I find it is a lot easier to manage than a custom VBA function and als
gets around the problem of contractors because they have no employe
number so no calculation is performed.

Regards

Adria

--
SandyU
-----------------------------------------------------------------------
SandyUK's Profile: http://www.excelforum.com/member.php...fo&userid=1748
View this thread: http://www.excelforum.com/showthread.php?threadid=54990