Comparing Two Sheets with Unique Relationship

Hi All,

I'm going CRAZY trying to logic this through.

I have two sheets that have some similar data but is very different from one another.
I've attached a much simplified example (Also below in text).

I want to run a macro on Sheets 1 and 2 which will net me a third sheet, showing me the difference between the two.

Please Login or Register  to view this content.

How on earth do I do this? Is this even possible?

I don't understand your data.
For instance do you allow the Sheet2 AD values to be found anywhere in Sheet1.

In any case this is clearly a much simplified example and probably doesn't represent the size or complexity of your actual data. We often find that when we give an answer to what is a trivial non representative example when the solution is used with the real world data it doesn't work because of factors like string length and other stuff which is important but hasn't been mentioned.

Therefore upload your real workbook (or at least a cut down copy), and manually add the results you expect to see. Clearly identify which is original data and which are the results and in a note clearly explain how you have arrived at your results.