Question about counting numbers

[Jarvis]

Hi
I have an excel sheet with an external link (say to cell B2). The value in
this cell can change at various times throughout the day. Is there a piece
of VBA I can put in to keep count of the sum total of values throught the
day in another cell please?

Many thanks for the help

J

 

[Norman Jones]

Hi Jarvis,

As a starting point, see J.E. McGimpsey'a Accumulator
page at:


Using a Cell as an Accumulator
http://www.mcgimpsey.com/excel/accumulator.html

 

[Jarvis]

excellent thanks very much, just what i needed.........