Question about counting numbers
 

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

Question about counting numbers
 

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



---
Regards,
Norman



"Jarvis" wrote in message
...
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

Question about counting numbers
 

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


"Norman Jones" wrote in message
...
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



---
Regards,
Norman



"Jarvis" wrote in message
...
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