At the bottom there is a formula solution turning on iterations

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

--


Regards,


Peo Sjoblom


"Brad Grow" <Brad wrote in message
...
I need to know if there is a way to create a formula that will allow me to
enter multiple values in a cell at different times and this formula will
sum
there values.
Example:
I would enter 10 in cell B3.
An hour later I might enter 25 also in cell B3.
After the second entry I would want it to automaticaly display 35.

Is this possible and how would it be done?

Thanks for your help.

And make note of the caveat about having no "audit trail" for error
checking.


Gord Dibben MS Excel MVP

On Wed, 28 Oct 2009 08:27:59 -0700, "Peo Sjoblom" wrote:

At the bottom there is a formula solution turning on iterations

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

OK. This is great- it can be done!

Pretty new at this so what do I do with this code? Copy and paste somewhere?

Thanks!

"Peo Sjoblom" wrote:

At the bottom there is a formula solution turning on iterations

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

--


Regards,


Peo Sjoblom


"Brad Grow" <Brad wrote in message
...
I need to know if there is a way to create a formula that will allow me to
enter multiple values in a cell at different times and this formula will
sum
there values.
Example:
I would enter 10 in cell B3.
An hour later I might enter 25 also in cell B3.
After the second entry I would want it to automaticaly display 35.

Is this possible and how would it be done?

Thanks for your help.


.

Here you go

http://www.mvps.org/dmcritchie/excel/install.htm

--


Regards,


Peo Sjoblom


"Brad Grow" wrote in message
...
OK. This is great- it can be done!

Pretty new at this so what do I do with this code? Copy and paste
somewhere?

Thanks!

"Peo Sjoblom" wrote:

At the bottom there is a formula solution turning on iterations

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

--


Regards,


Peo Sjoblom


"Brad Grow" <Brad wrote in message
...
I need to know if there is a way to create a formula that will allow me
to
enter multiple values in a cell at different times and this formula
will
sum
there values.
Example:
I would enter 10 in cell B3.
An hour later I might enter 25 also in cell B3.
After the second entry I would want it to automaticaly display 35.

Is this possible and how would it be done?

Thanks for your help.


.

OK. Finally got back on this little project and got it to work. Now how can
I make this work for more than one cell on a worksheet? I have played with
it a little bit and I can make it work anywhere on the worksheet, but only
one spot. Also is there any potential problems by having it apply to a range
of cells?

Thank you agaun for your time and assistance.


"Peo Sjoblom" wrote:

Here you go

http://www.mvps.org/dmcritchie/excel/install.htm

--


Regards,


Peo Sjoblom


"Brad Grow" wrote in message
...
OK. This is great- it can be done!

Pretty new at this so what do I do with this code? Copy and paste
somewhere?

Thanks!

"Peo Sjoblom" wrote:

At the bottom there is a formula solution turning on iterations

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

--


Regards,


Peo Sjoblom


"Brad Grow" <Brad wrote in message
...
I need to know if there is a way to create a formula that will allow me
to
enter multiple values in a cell at different times and this formula
will
sum
there values.
Example:
I would enter 10 in cell B3.
An hour later I might enter 25 also in cell B3.
After the second entry I would want it to automaticaly display 35.

Is this possible and how would it be done?

Thanks for your help.


.



.

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
Static dAccumulator As Double
Const WS_RANGE As String = "A1:A10" 'adjust range to suit.
If Not Intersect(Target, Me.Range(WS_RANGE)) Is Nothing Then
With Target
If Not IsEmpty(.Value) And IsNumeric(.Value) Then
dAccumulator = dAccumulator + .Value
Else
dAccumulator = 0
End If
Application.EnableEvents = False
.Value = dAccumulator
Application.EnableEvents = True
End With
End If
End Sub

Should pose no problem with a larger range.


Gord Dibben MS Excel MVP

On Mon, 9 Nov 2009 17:48:01 -0800, Brad Grow
wrote:

OK. Finally got back on this little project and got it to work. Now how can
I make this work for more than one cell on a worksheet? I have played with
it a little bit and I can make it work anywhere on the worksheet, but only
one spot. Also is there any potential problems by having it apply to a range
of cells?

Thank you agaun for your time and assistance.


"Peo Sjoblom" wrote:

Here you go

http://www.mvps.org/dmcritchie/excel/install.htm

--


Regards,


Peo Sjoblom


"Brad Grow" wrote in message
...
OK. This is great- it can be done!

Pretty new at this so what do I do with this code? Copy and paste
somewhere?

Thanks!

"Peo Sjoblom" wrote:

At the bottom there is a formula solution turning on iterations

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

--


Regards,


Peo Sjoblom


"Brad Grow" <Brad wrote in message
...
I need to know if there is a way to create a formula that will allow me
to
enter multiple values in a cell at different times and this formula
will
sum
there values.
Example:
I would enter 10 in cell B3.
An hour later I might enter 25 also in cell B3.
After the second entry I would want it to automaticaly display 35.

Is this possible and how would it be done?

Thanks for your help.


.



.

Really appreciate all the help you guys have given. I'd still be at square
one with this if it wasn't for you.

Gord; I was actually referring to having the original accumulator work in
many cells independently of each other. This code seems to make cells A1
thru A10 Accumulate in each cell but then as you go down the column they are
summing themselves up as well. Does that make sense?

I just need each cell to be an accumulator for itself. My actual range
would be D6 through K36. So basically I need to make the original McGimpsey
accumulator apply for this range.

Thanks again for your help.

"Gord Dibben" wrote:

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
Static dAccumulator As Double
Const WS_RANGE As String = "A1:A10" 'adjust range to suit.
If Not Intersect(Target, Me.Range(WS_RANGE)) Is Nothing Then
With Target
If Not IsEmpty(.Value) And IsNumeric(.Value) Then
dAccumulator = dAccumulator + .Value
Else
dAccumulator = 0
End If
Application.EnableEvents = False
.Value = dAccumulator
Application.EnableEvents = True
End With
End If
End Sub

Should pose no problem with a larger range.


Gord Dibben MS Excel MVP

On Mon, 9 Nov 2009 17:48:01 -0800, Brad Grow
wrote:

OK. Finally got back on this little project and got it to work. Now how can
I make this work for more than one cell on a worksheet? I have played with
it a little bit and I can make it work anywhere on the worksheet, but only
one spot. Also is there any potential problems by having it apply to a range
of cells?

Thank you agaun for your time and assistance.


"Peo Sjoblom" wrote:

Here you go

http://www.mvps.org/dmcritchie/excel/install.htm

--


Regards,


Peo Sjoblom


"Brad Grow" wrote in message
...
OK. This is great- it can be done!

Pretty new at this so what do I do with this code? Copy and paste
somewhere?

Thanks!

"Peo Sjoblom" wrote:

At the bottom there is a formula solution turning on iterations

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

--


Regards,


Peo Sjoblom


"Brad Grow" <Brad wrote in message
...
I need to know if there is a way to create a formula that will allow me
to
enter multiple values in a cell at different times and this formula
will
sum
there values.
Example:
I would enter 10 in cell B3.
An hour later I might enter 25 also in cell B3.
After the second entry I would want it to automaticaly display 35.

Is this possible and how would it be done?

Thanks for your help.


.



.


.

Poor testing on my part.

I will try to come up with something that works over a range of cells.

In the meantime hang in.........someone else may post a solution.


Gord

On Tue, 10 Nov 2009 19:31:25 -0800, Brad Grow
wrote:

Really appreciate all the help you guys have given. I'd still be at square
one with this if it wasn't for you.

Gord; I was actually referring to having the original accumulator work in
many cells independently of each other. This code seems to make cells A1
thru A10 Accumulate in each cell but then as you go down the column they are
summing themselves up as well. Does that make sense?

I just need each cell to be an accumulator for itself. My actual range
would be D6 through K36. So basically I need to make the original McGimpsey
accumulator apply for this range.

Thanks again for your help.

"Gord Dibben" wrote:

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
Static dAccumulator As Double
Const WS_RANGE As String = "A1:A10" 'adjust range to suit.
If Not Intersect(Target, Me.Range(WS_RANGE)) Is Nothing Then
With Target
If Not IsEmpty(.Value) And IsNumeric(.Value) Then
dAccumulator = dAccumulator + .Value
Else
dAccumulator = 0
End If
Application.EnableEvents = False
.Value = dAccumulator
Application.EnableEvents = True
End With
End If
End Sub

Should pose no problem with a larger range.


Gord Dibben MS Excel MVP

On Mon, 9 Nov 2009 17:48:01 -0800, Brad Grow
wrote:

OK. Finally got back on this little project and got it to work. Now how can
I make this work for more than one cell on a worksheet? I have played with
it a little bit and I can make it work anywhere on the worksheet, but only
one spot. Also is there any potential problems by having it apply to a range
of cells?

Thank you agaun for your time and assistance.


"Peo Sjoblom" wrote:

Here you go

http://www.mvps.org/dmcritchie/excel/install.htm

--


Regards,


Peo Sjoblom


"Brad Grow" wrote in message
...
OK. This is great- it can be done!

Pretty new at this so what do I do with this code? Copy and paste
somewhere?

Thanks!

"Peo Sjoblom" wrote:

At the bottom there is a formula solution turning on iterations

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

--


Regards,


Peo Sjoblom


"Brad Grow" <Brad wrote in message
...
I need to know if there is a way to create a formula that will allow me
to
enter multiple values in a cell at different times and this formula
will
sum
there values.
Example:
I would enter 10 in cell B3.
An hour later I might enter 25 also in cell B3.
After the second entry I would want it to automaticaly display 35.

Is this possible and how would it be done?

Thanks for your help.


.



.


.