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
--
sharon2006
------------------------------------------------------------------------
sharon2006's Profile:
http://www.excelforum.com/member.php...o&userid=30173
View this thread:
http://www.excelforum.com/showthread...hreadid=499259