I have 2 worksheets that I need to compare a column from each worksheet. If it doesn't find a match I need that offage to be placed on a separate worksheet with notation of which worksheet it came from.
Let me see if I can be more clear.
Sheet 1; Column B is comparing with Sheet 2; Column C
If Column B or C does not find it's match within one another, I want it to go to Sheet 3 and I want to know if the non-matched item was from Sheet 1 or Sheet 2.
Thanks!
Lori
Let me see if I can be more clear.
Sheet 1; Column B is comparing with Sheet 2; Column C
If Column B or C does not find it's match within one another, I want it to go to Sheet 3 and I want to know if the non-matched item was from Sheet 1 or Sheet 2.
Thanks!
Lori