Tnx J.E.
I'm Not good with macros yet but this served the purpouse
Worksheet Function Accumulator (using Circular References)
A two cell accumulator can also be constructed without VBA using circular
references. To avoid an error, first choose Tools/Options/Calculation (Mac:
Preferences/Calculation) and check the Iterations checkbox. Enter 1 in the
number of iterations box. Now enter the following
B1: =A1 + B1
B1 will immedately take on the value of A1, then will update every time A1
is changed (or the entire worksheet is calculated). Note that it is very
difficult to clear this accumulator - deleting the value in B1 deletes the
formula. One can either enter the negative of B1 or edit the cell.
The only thing I have to be carefull about is that after B1 is Added to A1
the value in B1 has to be removed or it will be added on Save Open Or on any
other calculation. otherwise its perfect. Know of anywhere I could learn
about installing Macros ?
