Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Once only calculation - help please
Hi -
I'd be very grateful if someone can help me with a bit of macro code that might achieve this. Really having trouble as my programming skill is diabolical!! I want to perform a "once only" calculation on rows of cells. When a reference cell changes from blank to a value it will trigger a calculation in another cell. When the reference cell changes subsequenlty it will not affect the value in the calculated cell. e.g. Cell - Formula - Value -------------------- Step 1 A1 blank B1 =A1 value blank Step 2 A1 value 10 B1 =A1 value 10 Step3 A1 value 20 B1 =A1 value 10 (stays at value 10 irrespective of value in A1) This operation would need to be replicated through hundreds of rows. Thanks in advance. Richard |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculation Setting in Excel | Excel Discussion (Misc queries) | |||
How do I use a check box to accept a calculation | Excel Discussion (Misc queries) | |||
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions |