try it
http://www.j-walk.com/ss/excel/usertips/tip073.htm

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Ben" escreveu:

Hi I am comparing two lists in excel. The first list contains part
numbers and it is my list. The next list contains part numbers and it
is the customer's list. I have compared both lists to determine what
the customer has and what I have. If the customer has it and I have it,
then the formular returns "yes" if not then "no." I would like to
create a macro that cuts and pastes the "no's" into a new column.

The Data is organized as follows

Customer Data (cells 2 thru cells 584)
Column A
Part No.
102634
..
..
..
-------------
My Data (cells 2 thru cells 953)
Column D
Part No.
102635
..
..
..