I need to compare rows on 2 separate worksheets.
I have an internal order worksheet (sheet 1)
I also have a head office shipping report.
The tricky bit is the data is often duplicated on the sheets.
Example:
Column A is the Order number
Column B is the Part number.
Column C is the Part number quantity
Under column A I may have the following order numbers:
Order # 123
Order # 456
Order # 789
Under column B I may have the following part numbers:
A112233
B445566
C778899
Now the tricky bit is:
Order Number # 123 may contain the following part numbers:
A112233
C778899
Order Number # 456 may contain the following part numbers:
B445566
C778899
Order Number # 789 may contain the following part numbers:
A112233
B445566
C778899
What I need to do is compare only Order Number #123, part number A112233 on sheet 1,
with Order Number # 123, Part Number A112233 on sheet 2
When comparing the lists I do NOT want to compare Order Number # 123, part number A112233 on sheet 1,
with Order Number # 789, part number A112233 on sheet 2.
Make sense??? Basically I want to compare apples with apples but not with oranges
I hope so and if any of you geniuses out there can figure this one out for me I will owe you my eternal gratitude!!
Bookmarks