I have two work sheets I want to combine.
Sheet1 has these columns:
Part number, Description, Cost.
Sheet2 has these columns
Part number, Quantity.
Say i wanted to combine these two sheets and have the part numbers match up.
Now they both don't have the exact same records under part number. Sheet2 may have a few more records, however all of the part numbers do match up.
How would I achieve this?
Sheet1 has these columns:
Part number, Description, Cost.
Sheet2 has these columns
Part number, Quantity.
Say i wanted to combine these two sheets and have the part numbers match up.
Now they both don't have the exact same records under part number. Sheet2 may have a few more records, however all of the part numbers do match up.
How would I achieve this?