Comparing 2 worksheets & extracting matched and unmatched data.

[Closed]
Report
Posts
1
Registration date
Monday August 17, 2015
Status
Member
Last seen
August 17, 2015
-
Hey guys,

I'm trying to compare one column in a worksheet with another column in another worksheet and also at the same time, extract matched values or data into a whole new worksheet, and also doing the same for unmatched or leftover data or values. How do I go about doing this?

for example:

comparing both column B in worksheet 1 & 2, there are some matching values in both of them. Then, taking these values, the corresponding row will be taken out and be placed in a new worksheet.

likewise, if there are any values that do not match at all, then they will ALSO be taken out and placed in an entirely new worksheet as well.

I'm still new to this and would like some help on this.

Thanks in advance guys! Appreciate it!