Hi newdoverman

That looks great but i wanted the D column to show the value in money not copy over M column values.

Sorry might have been my poor explanation so in D2 it should say £16.99 then the E column add B2 and D2 to get full price.

I need to show VAT amount after it works out which one to apply.