Requirements:

First it needs to search in column D for a numeric number (personnel
number) and look it up in a list from sheet 1 (contains name and
personnel number) and once it find a matching personnel number. It
will copy and paste the personnel number in column A while the name
will be paste in column B. When it encounters a blank cell it will
jump to another row in column D and look for a personnel number again.
Once it jump for the 15th time and not yet find a personnel number, it
will now stop.


--
japorms
------------------------------------------------------------------------
japorms's Profile: http://www.excelforum.com/member.php...fo&userid=6544
View this thread: http://www.excelforum.com/showthread...hreadid=468141