Hi all,

I have 2 worksheet

1. Sheet2 - Source sheet
2. Sheet1

I need a macro that compare the value between this worksheets.
The condition will like: -

1. If sheet2 value Not exist in Sheet1, then add the new value to column C and display the status in Column F, sheet1 as "New"

2. If sheet1 value Not exist in Sheet2, remain the value and display the status in Column F as "Canceled" in sheet1.

3. I need have a input range that allow user to select the start row of data that need to be compare.

4. Compare button will place in Sheet1.

example layout of the worksheets:

Sheet1:

Row ---- Column (C) ------Column (F)
21 ---------- AAAA --------
22 -----------BBBBB -------- Cancel
23 ---------- CCCCC -----------New


Sheet2:

Row ---- Column (C)
2 ---------- AAAA
3 -----------CCCCC

*Row -- Indicate the start row to place the data


Anyone have an idea about it...???
Thanks!

Regards,
Sharon