You should use a database for this type a data proccessing.

it would be one SQL statment to get a recordset with the desired
records.

but if you have to stick to Excel take these steps:

1) sort your product sheet on the competetors article code
2) sort the clients column the same way.
3)take the first item in the client list aand search for it in your
list
4)if found copy the row/record to another sheet
5)read the next item from the clients list and continue the search on
the row you have copied.
6) stop at the last row of your productsheet (PROBLEM)
7)or if you have found the last item (SUCCES)

this way you have to walk through your product sheet once......There's
one BIG drawback if the customer has entered a code not in your
productsheet you have to do something like skip it and search the next
item in the column or generate an error


--
Dnereb
------------------------------------------------------------------------
Dnereb's Profile: http://www.excelforum.com/member.php...o&userid=26182
View this thread: http://www.excelforum.com/showthread...hreadid=395923