Hi
I have tried to find information on this using the search feature but
so far no luck. I have a expense spreadsheet that needs to be able to
display numbers in different currencies. The currency used in each
worksheet is selected from a drop down list. Is it possible to write
a macro that will update a particular range of cells to match the
currency selected from the drop down list? The list is generated from
a separate worksheet which contains the currency formatting in the
cell to the right. I was thinking a macro using a lookup function
could possibly do the trick.

Any help would be greatly appreciated.

Regards

Marcello