I have a table of data that needs displaying in two currencies, £ and $ (not simulataneously). How do I write a macro that multiplies all values in the table by 1.4 (if currently in £) or 0.6 (if currently in $) to give the other currency
Thanks
Thanks