Converting currency
 

Hi Folks
I download a currency table from the net. And is put into excel format. My columns ar
Vendor Inv Code Total Currency
I need to convert euros to us $ and Hungry to us $ this spreadsheet also contains US $. I'm trying to write a macro for this
I've tried to filter but since the report is not stagnant and sometimes their are more euros sometimes less...ect. It doesn't seem to work..
Any ideas
Thanks
D