Automatically updating currency exchange rate?

Metamag · #1 09-04-2012, 08:48 AM

Can this be done?

Right now I have two very simple currency conversion formulas, like =SUM(A1:A15)/5,92 and =SUM(A1:A15)/7,46 and then I just added currency symbols via format cells.

But this means I would have to constantly check online and manually readjust values. Obviously I would have to make some elaborate checking online function and importing values from a very specifically formatted website so it can recognize which values to check and download, if such an option even exists?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Create automatically updating fields in Word 2010	tryer	Word	8	01-08-2014 12:39 AM
Monthly Growth Rate Formula	meggenm	Excel	2	04-22-2013 09:21 PM
Can you stop Cross References from Updating Automatically?	Welshie82	Word	2	05-14-2012 02:10 AM
Formatting Cells for Currency and Accounting	Sparetyme	Excel	1	07-11-2010 01:26 PM
change currency $ to £ on excel invoice help	deanorx7	Excel	3	07-08-2008 04:40 AM