The macro is intended to compare
Column C of two different sheets.

For the exercise let's call sheet1 and sheet2.

Compare col c sheet 1 vs col c sheet 2.
If duplicates then on sheet col i write "text".


--
wayliff
------------------------------------------------------------------------
wayliff's Profile: http://www.excelforum.com/member.php...o&userid=29860
View this thread: http://www.excelforum.com/showthread...hreadid=501783