I have a stock sheet and a bill of materials sheet, I would like to type a stock item number into the bill of materials sheet and have it search the stock sheet for the matching number and then copy set cells in the row to specified cells in the BOM sheet.
So it goes;
Input stock number in BOM in cell A3.
Search Stock sheet column A for matching stock number.
Find matching stock number in row 17 for example.
Copy cells B17, C17 and E17 on stock sheet to cells B3, B4 & B5
Hope that makes sense!