Excel Fixing a value in excel 2007

[toxic_tune]

I want to fix a value in a cell, such that when I enter a value, it is saved and when I enter another value, it is added in the old value. For example If i enter 5 in D1, it is saved and when I again enter value 3 the value in D1 becomes 8. Kindly show me the easiest way to do this....

 

[Ian]

Hi Toxic_Tune and welcome to the forums.

I don't know of a way to achieve that, although you can no doubt read up on VBA programming to code that feature in. You can easy achieve what you are after by using adjacent cells, but I can't think of a way to do this in an overlapping way.