View Single Post
 
Old 09-04-2012, 08:48 AM
Metamag Metamag is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Apr 2011
Posts: 23
Metamag is on a distinguished road
Default Automatically updating currency exchange rate?

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?
Reply With Quote