Adding to a cell's previous value (Cell1+Cell2=Cell2New)
Posted by Richard Maule on August 08, 2000 8:26 AM
I have two cells. One is a running total (Cell1) and the other is a value over a specified period of time (Cell2). When I place a number in Cell1, I want Cell2 to add the value in Cell1 to itself creating a new value (Cell1+Cell2=Cell2New).
Unfortunately this creates a circle function. Making a 3rd cell would be simple but not effective. Is there any way to create a function or macro that will take the original value of a cell, add to it and then place the new value in the same cell?