Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I automatically change currency depending on another cell .
I am writting a worksheet that will be used on many projects. Each project
will have a copy of this worksheet and I will enter takings from each project as they run. These projects will run in several countries and therefore the takings will either be in pounds (sterling) or euros. I was wondering if it is possible to create a drop down box or a check box that will give me the option to change the currency that the sheet is using and for all other currency cells in the sheet to react to that and change accordingly. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
get cell to automatically change colour depending on text in adja. | Excel Discussion (Misc queries) | |||
Automatically fill following cells depending on one cell. | Excel Discussion (Misc queries) | |||
Currency format depending on drop-down box | Excel Discussion (Misc queries) | |||
how do i change currency value into words automatically | Excel Discussion (Misc queries) | |||
How do I get the font color to change automatically depending on | Excel Discussion (Misc queries) |