Continuosly adding data from a cell to a forumal

[Plasma]

Hi.

Try to figure this out....

Workbook with 2 sheets: In sheet2, it adds data put in sheet from
that listed in column A. is there anyway to setup the forumla in
sheet2 so it will continuosly add data from sheet1 column A without
changing the formula everytime new data is introduced?

 

[L. Howard Kittle]

On sheet 1 select a large enough range to accomidate your entries and name
it Data. On sheet 2 =Sum(Data)

HTH
Regards,
Howard

 

[Gord Dibben]

Plasma

Sounds like you want an "accumulator" cell/formula.

There are several ways to achieve this, none of them fool-proof.

Check out the code at John McGimpsey's site.

Read the caveats before deciding to use the "accumulator" method.

http://www.mcgimpsey.com/excel/accumulator.html


Gord Dibben MS Excel MVP

Hi.

Try to figure this out....

Workbook with 2 sheets: In sheet2, it adds data put in sheet from
that listed in column A. is there anyway to setup the forumla in
sheet2 so it will continuosly add data from sheet1 column A without
changing the formula everytime new data is introduced?

Gord Dibben MS Excel MVP