Hi

I have two worksheets, which both have similar data.

I need to compare sheet1 to sheet2 and the data that in sheet1 that is
not in sheet2 place into sheet3.

e.g.

sht1 sht2 sheet3
aaa aaa ddd
bbb bbb
ccc ccc
ddd eee

Please help!

I tried the compare macro in forum, but error occurs and cannot debug!


--
unsworthcl
------------------------------------------------------------------------
unsworthcl's Profile: http://www.excelforum.com/member.php...o&userid=23946
View this thread: http://www.excelforum.com/showthread...hreadid=375745