Correlating items from 2 different spreadsheets
Hello,
I have 2 different sheets, 1 for ship A and 1 for ship B.
Both these ships have part numbers and prices associated with them. Lets
say Column A has the part numbers and Column B has the prices associated with
these part numbers. My task is to compare the 2 sheets, find part numbers
that they both have in common and insert the price from Ship B into Ship A's
sheet.
I am thinking that this will be some sort of Macro, but I dont have really
any experience with these. If someone has a different approach, that would
be great.
Thanks
|