JoeC wrote:
I would like to convert a range of figures to a set
currency , say Barbados $ to £Sterling , based on the
current daily Exchange Rate , and update or refresh from
the web site whenever I connect to the internet.


The easy bit is the formula to do the conversion having got the current
daily rate.

You will need a Web Query to bring in the exchange rate.
Details vary according to Excel version but something like Data /
Import External Data / New Web Query.

You will need to know a suitable web site that provides the exchange
rate information.

Updating "whenever you connect to the internet" is not easy.
You can have it updated whenever you open the workbook - I guess if you
are not connected it will either prompt you to connect or will fail to
update. Depends on your setup.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup