| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change currency on all sheets based on one cell value
Hello,
I need to change currency formatting based on one selected value. So, if the user changes Italy as their base country, I want the currency to change to ‚¬. If they choose the UK, I want the currency to change to £. I have a cell (Inputs!A1) which updates to 1 for euro country and 2 for the UK. The cells ranges that need to change are Inputs!L94-M94, Inputs!L96:M98 and Calculations!A1:D5. Is this doable? Many thinks in advance. -- Johanna |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Summing based on currency format of Cell | Excel Programming | |||
| Change Currency Format of Cell based on another Cell | Excel Worksheet Functions | |||
| SAP BW Report - Putting the Unit of Measure or Currency in another Cell based on Format Cell | Excel Programming | |||
| Change Cell Value Across whole WorkSheet/ Workbook if cell type is currency | Excel Programming | |||
| How do I automatically change currency depending on another cell . | Excel Programming | |||
Linear Mode
