I have a spreadsheet of part numbers (columns A) with corresponding attributes (columns B, C, D, E). I need to create a macro that updates data from this workbook to another workbook (2nd tab) with corresponding part numbers. The workbook that needs updated has more part numbers and extra columns than the correct workbook.

Example: Correct Data
Part Number Weight Length Width Height
12345 27 32 45 12

Find part number and replace corresponding incorrect data
Part Number Price Weight Description Length Width Height
12345 $12 35 description goes here 38 24 18

I just don't know where to start. Would it be easier to achieve this fixing one column at a time or can I look for a part number and replace contents of the cell that needs updated?

thanks!