View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Reebis Reebis is offline
external usenet poster
 
Posts: 5
Default 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