I have created the macro to check the changes compare to the values in sheet1
vs sheet2, if anything changed more than certain amount, it will be copied
and pasted to another sheet. The thing is I couldn't figure out how to find
out the names only on sheet1 or only on sheet2. for example, if i check
column A on each sheet, how can i find out the names only on sheet1 and only
on sheet2, then i can copy, paste the value to another spread sheet?

Thanks a lot.

Ming