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?
|