View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default reconciliation in different currencies

Hi,

Select cell A1 on a worksheet then

Data|Import external data|Import data
select
MSN MoneyCentral Incvestor currency rates.iqy

The sheet will fill with all the latest exchange rates which cna be
referenced for your conversions.

Mike

"jzambran" wrote:

I would like to create a reconliiation of income and expenditure where I can
press a button (or choose from a drop-down menu) and the numbers
automatically will convert to their equivalent in Euros or US$. Is this
possible in Excel?