Hi all,

can anybody help by providing a VB code novice with some code to do the
following...

Search cells E1:E100 for this reference : 07YYDK
when it is found copy the corresponding name from cells C1:C100 to the next
available cell in column AA and then DELETE the reference it has just found
in cells E1:E100.
Then (and the important bit) search the cells again E1:E100 for the same
reference and keep doing this until the reference can no longer be found.

eg

O7YYDK
G23XXF
98HJUY
O7YYDK

from the above list, when the code is run, it will search the list for the
code O7YYDK and when/if found take it and the corresponding name from cells
C1:C100 and paste them into the first available cell in column AA

Then, deletethe code from the original list (cells E1:E100) and perform the
seach again, and loop until the code isn't found,

Hope this makes sense and somebody can help

Thanks