I have 1 XLS file, which contains two sheets.
SHEET1:
A: PartNumber
B: Price
SHEET2:
A: PartNumber
B: Price
Sheet1 has data for both PartNumber (A) and Price (B), but Sheet2 only has PartNumbers (A) and Price (B) is an empty column.
I am trying to populate Col B in Sheet2 with prices, where Sheet2-A matches Sheet1-A.
NOTE: All columns have a header (A = PartNumber and B = Price).
Bookmarks