Copy / Paste picture and price from one tab to another..

Hi
I am currently trying to set up a spares catalog, on one tab "Parts Prices" i need to copy and paste the highlighted cells to highlighted cells on "Parts Quote" but cannot find the paste option that allows the price and picture to be correct. not sure if its trying to paste the formula
in D2 (conversion factor from euros D3) "parts prices")) into D2 (parts quote) which also has a formula in it to multiply price by quantity= total.
any advise would be greatly appreciated, thanks....

You need to have the picture in the cell, right now it is floating on top of the cell. See this video. https://trumpexcel.com/insert-picture-into-excel-cell/

Hi dweingar
Thanks for your advise, the picture is not the issue, its pasting part of the formula from D2 "PARTS PRICES" into D2 "PARTS QUOTE" as £1.25 and not £62.50!

I would create a separate worksheet with the currency conversion rate and then reference the conversion rate from that cell when and where it is needed.