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

abdelfattah

Board Regular
Joined
May 3, 2019
Messages
87
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:

ITEMBRANDTYPEORIGINQUNTITY
110.00-16 8PRFSMTHI7
210-18 10PR FGFG***10
310-16.5 8PRFGINDO20

<tbody>
</tbody>





sheet2:

ITEMBRANDTYPEORIGINQUNTITY
110.00-16 8PRFSMTHI7
210-18 10PR FGFG***10

<tbody>
</tbody>





what i would the result in sheet3:


ITEMBRANDTYPEORIGINQUNTITY
110.00-16 8PRFSMTHI0
210-18 10PR FGFG***0
310-16.5 8PRFGINDO20

<tbody>
</tbody>
 
Last edited:

pbornemeier

Well-known Member
Joined
May 24, 2005
Messages
3,692
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?
 

Forum statistics

Threads
1,077,774
Messages
5,336,165
Members
399,067
Latest member
CJWFM

Some videos you may like

This Week's Hot Topics

Top