Repetative Value update

[Radical_Magic63]

Not sure if i worded title correctly but heres what Im trying to do:

I have a value in A1 (say 100). This comes from another sheet and can not be changed.
I want to take that value and put it into A2 so now A2 is =100.
Now I want to be able to enter a value into A3 and have that value subtracted from A2 but I want A2 to become that result.
A2-10 = 90.

Now I need to be able to enter another value into A3 and have that subtracted from A2

A2 - 20 =70. and repeat this until value is zero.

[XLent]

you either need to

a) use VBA (consider using the worksheet change event on A1 & A3, specifically)

right click on Tab name to which this code should apply, select View Code and paste below into resulting window.

Please Login or Register  to view this content.

b) enable iteration (calculation option) - with max iteration set to 1

Please Login or Register  to view this content.

result should be 100
add 10 to A3 -- A2 should drop to 90, and repeat...
to reset A2 (to A1), clear A3 - A2 should revert to 100

edit: the firewall is preventing me from posting ideal code but you might want to include a With/End With re: final Target (row 3 in Select Case) such that you can keep A3 the active cell.