I start with a collumn of financial data. The value of the last row is
the sum of all the other rows. If this number is negative however, I
want the value of the number in the first row to update by adding the
absolute value of the last row figure to itself.

A 100 <-- I want this number to recalculate with the absolute value of
E
B 50
C 50
D-250
E -50 <-- sum of rows A through D

I know this is troublesome but I think I saw somewhere a colleague used
a function to copy out values to other cells in order to break the
circular refernce in a problem like this.

Anyone have any suggestions?
the n00bish


--
mmednick
------------------------------------------------------------------------
mmednick's Profile: http://www.excelforum.com/member.php...o&userid=29404
View this thread: http://www.excelforum.com/showthread...hreadid=507728