Compare and Lookup

[sharon2006]

Hi All,

I need helps from all of you regarding the macro i need to do.
The Attach file is the work that i had completed, but i need to make some change to my marco, so i need help from all of the expert.

The marco I had done:

I want to compare between 2 worksheet named sheet1 and sheet2.
sheet 2 work as source file.
- If the value in sheet1 not exist in sheet2, set the status in column B(sheet1) as "Canceled".

- If the value in sheet2 not exist in sheet1, add new data to sheet1 and set status as "New".


what i need now is make the changed of the column of data to below example:

Sheet1:
Column C Column F
A
B - Canceled
C - new



Sheet2:
Column Z Column AD
A
C


Hope all of u can helps me.
Thanks !!

Sharon