formula to add number

[pradeep kalele]

In my following simple table, I have only three colomns:

Executive Today's Business Till date business
abc 1 10
xyz 2 22

In column "Today's business I change the business brought in by the executives. I want that it should be added automatically to next column figure. In this example, 10 should become 11 and 22 should be come 24 by a formula. please help

Thanks & regards,

Pradeep Kalele

 

[NARAYANK991]

Hi ,

That is not possible , unless you enable iterative calculation and change your calculation mode to manual. Even then it is dangerous because each time you press the F9 key , the value in C2 will change.

It is much better to do this using VBA.

Narayan