currency conversion

[Michaelbbeck]

Hi Guys

I have two questions.
1. I need to convert all pricing USD in a spreadsheet to other currencies from a drop-down menu. Eg native currency is USD and the drop-down offers AUD, CAD, EUR and GPB. I simply want to pick a currency and it updates to the currency selected.
2. I've been able to pull an XML in integration from a feed from an fx site that updates every 12 hours. This is in a separate sheet.
3. I also need to make sure that the new currency also has the correct prefix eg $, £, etc

Thanks in advance for any advice.

MB

 

[Michaelbbeck]

Bump