Hi I need with constructing a macro or something to copy and replace a large sum of data.

I have two spreadsheets to move data from.

I have "Spreadsheet A" (A) with "Column A Cell 1" (A1) named "Code" and "Column E Cell 1" (APrice) named "New Price".

I have "Spreadsheet B" (B) with "Column A Cell 1" (B1) named "Code" and "Column D Cell 1" (BPrice) named "Price".

What I want to do is, IF A1 = B1 then Copy APrice to BPrice but have this done all the way down the spreadsheet, over 800 lines.

The only issue is the Code on A might be "ABC 12345" but on B it might be "12345" but these are the same product, don't know if this would cause any errors, but any help would be highly appreciated.

if possible can the changes be highlighted too?

Thanks again