Search results

I found an even easier way. I created two columns: FX Name FX Symbol Listed out all of the names and symbols in a worksheet, named the range fx_rates then when the user selects the currency they want to convert to, the user chooses the currency in the pull down menu, to convert all...

Thanks Hui, but i also need the numbers to stay numbers since i am also doing some other calculations, i.e. cost per month and cost per year. Thanks Narayank991. i will test out some of those VBAs

just for an example... lets say I have this A B Name Cost Apples $1.00 Oranges $0.50 Veggies $5.00 the user now selects the currency in which they want to see the prices in, and they select the british pound. After I do my currency conversion, how do I...

I have a price sheet that is all based on USD ($). I also have a list of foreign exchange rates in which the user can select when they go to the pull down menu and select the appropriate currencies. Once they have selected the currencies, I can easily convert USD to the currency, however I...