Automatically change all currency cells based on 1 drop down list

I am really looking for help here, please.

I have created a dropdown list where i can select different currencies. Now what i want to be able to do, is once i select a currency from the drop down list, it automatically change the cells that have a currency in it.

It would help if you attached a sample Excel workbook.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Don't try to use the Paperclip icon, as it doesn't work on this forum.

Hope this helps.

Pete

Hello.
Not sure if this is what you are looking for.
Choose the currency on cell C3. The yellow cell will change according to the chosen currency.
Oct

Thanks, but unfortunately not what I am looking for.

I have attached a demo copy of the spreadsheet minus a few pages as they are personal client information.

But if you look at the attached. Cell F3 is were you will select the currency, the cells E20, K12 and K16, the actual currency should change.

The attached is used for client reviews. Some client hold different currencies and as a business we have over 7,000 client to manually change each cell can become tedious. Currency conversion is not an issue as I don’t need to convert the currencies exchange rate, but rather just currency symbol.

Thanks, I have now attached a copy of the doc.

Hi Alex,
Not an elegant solution but if inserting two columns is not a problem then this should work.

Oct

Hi Oteixeira,

I initially tried this as it was what i used in the past. However as there are now graphs and charts that show values, this method does not work, as the graph will show just numbers and not the number in the represented currencies.

I see...It seems the only chance here is to use VBA and format the desired cells according to the chosen currency.

Oct

My Excel skills arent to bad. But I have no clue on how to do VBA coding. I appreciate the help.

Ok,
Check the uploaded file. You will need to allow macro execution when you open it.
Let me know if it worked
Oct

I've not been following this closely, but couldn't you use conditional formatting to change the currency symbol depending on the value in the drop-down?

Hope this helps.

Pete

Hi Pete.
Forgot about that option. You're absolutely correct.
Oct

Hi Oteixeira,

Thanks for the attachemnt, it does work. Just two questions, how do I now format the rest of the cells in the spread sheet to get this to work? Then on my side the currency is reflecting on the far right and not on the left of the numbers.

Hi Pete,

How would i get this to work. Not to up to date with conditional formatting.

Hi everyone,

I did some research and managed to figure out the conditional formating of cells. Thank you for the help.

Hi all,
I too am looking into this, would love to hear how you managed this with conditional formatting please

many thanks

Leigh

you do a conditional format for each currency

use formula to determine which cells to format
=$F$3="Euro"

then go to format, choose number and select currency as the format with euro

repeat for the other currencies along the same lines

Hi Davsth,
Thank you!! This makes sense!!

Hi Ali,
Apologies, will take this into consideration for future posts.

Leigh