Compare sheets

[alogoc]

Hello excel forum

I know,there are "compare sheets" threads everywhere,but i think every thread is different,because we want different comparison and different results

To the point now.What i actually want to do is a "turnout" of difference between two sheets.Both sheets use columns A and B.
On column A there is a code and column B the quantity of the code.
So obvisously i want to compare those two columns of these two sheets,and paste the results on a different sheet.

The difficult part is that the same code of a cell in Column A with its column B must be sorted so i can see the difference...else it would be a mess.

I have an attachment to see for yourselves.


Thanks for your help

[MickG]

Hi, Try this:-On sheet (3) of you returned file, Delete new Dups values in Columns "A to C" , then re-run code to ensure its working.
Regards Mick

[alogoc]

Seems to work fine buddy!Thanks a lot!
Although,is it possible to adjust it a little bit to show only the differences,or with will get you in trouble?

Unless there is another way to with a fuction of excel?

[MickG]

Posting Oversight (attachment)!!!!

[MickG]

Hi again, Try this:-
Regards Mick

[alogoc]

Excellent!Thank you so much for giving part of your time to help me!