Michaelbbeck
New Member
- Joined
- Dec 28, 2014
- Messages
- 25
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
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