Dear all,

I have a spreadsheet which tracks various types of expenses. Some are in
US$ others in foreign currencies.

Here is what I am trying to accomplish:

1. From one single worksheet/interface, I would like to be able to directly
enter an expense if it is in $US (no problem there!). If the expense is in a
different currency, I would like to be able to hit a button linked to the
same cell which brings up a small dialog box which asks for the currency, the
exchange rate, the expense total in that currency and the expense category.
Once entered, the cell would show the expense amount converted in $US based
on the information entered.

2. In addition, I'd like to be able to see the details behind a converted
item, i.e. by rolling over the cell or clicking somewhere that brings up the
details (conversion rate, original amount and foreign currency)

3. Lastly, I want to be able to view and print out all the information on
the expenses in foreign currencies only all together (arranged by category of
expense)

Any suggestions?

And thank you in advance. This group is excellent!!!

Karim