I have a column of mixed currencies as below and want to create a new column with all these values converted to GBP.
Can I set up a macro to pick from the spreadsheet the current exchange rate I have input for the 5 currencies used in the column and it creates a new column with all the amounts convered to GBP ?
Have never done a Macro before so new to this.
Total price
£17.50
£5.99
AU $16.37
EUR 87.00
£10.99
£7.99
£35.50
£10.99
US $31.29
EUR 45.47
AU $33.91
AU $214.11
AU $214.11
Bookmarks