P
PO
Excel 2003, sp2
Hi,
My worksheet has a group of cells (range A3:B10) where the user can enter
numeric values. The user can also enter a percentage value into range B1.
When the user enters the percentage value into B1 I want the numbers in
A3:B10 to display the original value multiplied by B1.
A3:B10 however doesn't contain any formulas (since the user can enter values
and "sabotage" the formulas). I want the original values to remain intact
and just display the new value
If I use macros to update the values I loose the original values.
Is this possible without using formulas (and without using macros), i.e.
using some kind of formatting code?
Regards
PO
Hi,
My worksheet has a group of cells (range A3:B10) where the user can enter
numeric values. The user can also enter a percentage value into range B1.
When the user enters the percentage value into B1 I want the numbers in
A3:B10 to display the original value multiplied by B1.
A3:B10 however doesn't contain any formulas (since the user can enter values
and "sabotage" the formulas). I want the original values to remain intact
and just display the new value
If I use macros to update the values I loose the original values.
Is this possible without using formulas (and without using macros), i.e.
using some kind of formatting code?
Regards
PO