I am trying to add $5 to an existing cell value when the value of a different cell is modified.
L L Johnson Feb 5, 2009 #1 I am trying to add $5 to an existing cell value when the value of a different cell is modified.
S Sheeloo Feb 5, 2009 #2 What do you mean by modified? Also any formula can not refer to the value of the cell it is entered in... You may use Worksheet_Change(ByVal Target As Range) to update the value
What do you mean by modified? Also any formula can not refer to the value of the cell it is entered in... You may use Worksheet_Change(ByVal Target As Range) to update the value
G Gord Dibben Feb 5, 2009 #3 Not easily done without using a helper cell because formulas can only pull and not push. To do it in-cell you either use a circular reference in A1 with iterations set to 1 or VBA code. See JE McGimpsey's site for help on an accumulator with methods for both the above. http://www.mcgimpsey.com/excel/accumulator.html Gord Dibben MS Excel MVP On Thu, 5 Feb 2009 14:33:44 -0800, L Johnson <L
Not easily done without using a helper cell because formulas can only pull and not push. To do it in-cell you either use a circular reference in A1 with iterations set to 1 or VBA code. See JE McGimpsey's site for help on an accumulator with methods for both the above. http://www.mcgimpsey.com/excel/accumulator.html Gord Dibben MS Excel MVP On Thu, 5 Feb 2009 14:33:44 -0800, L Johnson <L
