Thank-You!!! for the macro works beautifully.

One more request for the same problem
============================

suppose all the values in column C do not match with those in colum
A.

can the script write out those values from column C , which it did no
find in column A , into another column G.

Thanks for all the help.

--
Message posted from http://www.ExcelForum.com