How to auto import / update exchange rate on internet into a cell?
Posted by Peter van Biezen on August 23, 2001 5:28 AM
Good day Mr. Excel,
I am a buyer for an international offshore company. As a buyer I purchase thousands of items per month, from a lot of different countries all over the world.
Constantly I have to compare prices in different currencies and recalculate them into EURO or USD. Ofcourse you need to work with accurate exchange rates.
I have made a fairly simple spreadsheet which calculates a value from a certain currency into other most used and common currencies or into the currency of a counter bid.
But always I have to look into the internet for accurate exchange rates, and copy them into the correct cells.
Is there a possibility to automise this, in such a way that when you start up your spreadsheet, it automatically imports (Copy/Pastes?) the correct rate from the location on internet into the correct cell?