How to get a cell formula to automatically paste values

Hi all,

I am looking for some assistance with my limited Excel knowledge to find a way to hard paste values after a cell calculates a formula.

The problem:

I have an expense sheet with expenses in various currencies. For tracking I have a formula that converts into one currency. Naturally the price changes along throughout the year and will cause accounting issues down the line.

I am looking for a way to do the calculation when the expense is inputted but paste the value in another column so it is not affect by the change in currency price.

I have attached an example to help with understanding.

Thanks in advance,

Adam

Calculation help.xlsx

Thanks for the reply.

VBA knowledge is very limited but happy to give it ago.

Perfect,

Thanks a lot for the help!