code compare values of columns into two sheets and result in another sheet

[abdelfattah]

hi, everyone i would code to show difference values between columns into two sheets and show the result in another sheet for more explanation


sheet1:

[TABLE="width: 578"]
<tbody>[TR]
[TD]ITEM[/TD]
[TD]BRAND[/TD]
[TD]TYPE[/TD]
[TD]ORIGIN[/TD]
[TD]QUNTITY[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]10.00-16 8PR[/TD]
[TD]FSM[/TD]
[TD]THI[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]10-18 10PR FG[/TD]
[TD]FG[/TD]
[TD]***[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]10-16.5 8PR[/TD]
[TD]FG[/TD]
[TD]INDO[/TD]
[TD]20[/TD]
[/TR]
</tbody>[/TABLE]





sheet2:

[TABLE="width: 578"]
<tbody>[TR]
[TD]ITEM[/TD]
[TD]BRAND[/TD]
[TD]TYPE[/TD]
[TD]ORIGIN[/TD]
[TD]QUNTITY[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]10.00-16 8PR[/TD]
[TD]FSM[/TD]
[TD]THI[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]10-18 10PR FG[/TD]
[TD]FG[/TD]
[TD]***[/TD]
[TD]10[/TD]
[/TR]
</tbody>[/TABLE]





what i would the result in sheet3:


[TABLE="width: 578"]
<tbody>[TR]
[TD]ITEM[/TD]
[TD]BRAND[/TD]
[TD]TYPE[/TD]
[TD]ORIGIN[/TD]
[TD]QUNTITY[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]10.00-16 8PR[/TD]
[TD]FSM[/TD]
[TD]THI[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]10-18 10PR FG[/TD]
[TD]FG[/TD]
[TD]***[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]10-16.5 8PR[/TD]
[TD]FG[/TD]
[TD]INDO[/TD]
[TD]20[/TD]
[/TR]
</tbody>[/TABLE]

 

[pbornemeier]

Can the BRAND column name be used to match the rows between sheets?
Or can there be the same brand with different TYPE and/or ORIGIN?

Can there be multiple instances of the same item in each sheet?
Could the item in row 3 be repeated in row 300?