Update a vaule of a cell after using it for a calculation

N

ndavies

Is it possible to perform a calculation on a cell using it value an
then to update that cell with the new value created by th
calculation.

I know this will perform a circular reference, but I'm sure I have see
somewhere a way around this.

Any help muchly appreciated.

Example

A1 = 4
B1 = 10

I want the value of A1 to change after performing the followin
calculation - A1 = sum (B1 - A1)

A1 should update from "4" to "6
 
F

Frank Kabel

Hi
not really possible with formulas. you have to use VBA /
an event procedure. In your case the worksheet_change
event.

Would this be a feasible solution for you?
 
Top