Hi Shaolin,

I've posted the final routine, not sure if this will help you any?

From a list of 4 digit codes, in Column A, it searches for each code in a picture list in Column D.
If any instances are found the entry from column D is put into Column B alongside the 4 digit code.
A check is done to see if there is a second instance, if there is, this is put in to
Column C in the relevant position.

Hopefully you may be able to utilize something from it.

I found the articles below useful.

http://www.techonthenet.com/excel/macros/copy_data2.php

http://www.techonthenet.com/excel/macros/copy_data3.php

http://www.techonthenet.com/excel/macros/copy_data4.php

Regards

Nick