It's difficult for me to create a code since I'm not really clear what
you want to gain. What is your criteria in the IF statement? Is it like
copy all the rows if column C = YES? Do you need to compare any value
between this two sheets like if column C = "Yes" and column A in sheet1
= column B in sheet2?

Best regards,


--
hideki
------------------------------------------------------------------------
hideki's Profile: http://www.excelforum.com/member.php...o&userid=18903
View this thread: http://www.excelforum.com/showthread...hreadid=398522