Latest Currency Rates from a website

[RashmiD]

Hi,

Is there any way we can directly pull the latest currencies from a website every time we select a certain currency from a drop down list?

Eg. I want to convert a list of rates from USD to NOK. So I have a drop down cell, A2 - "USD" and "Convert to" drop down list in cell B2 - "NOK" and latest conversion rate in cell C2. I am using xe.com for conversion.

This conversion should happen on a click of a button instead of auto refresh as the file size is huge.

Thanks,
Rashmi