Two cell accumulator
 

I would like to know if it is possible to have a running total using only two
cells. I have many rows of items that are tracked each week and each item
rolls up to a monthly total. What I would like is to have the following: B1:
=A1+B1, B2: =A2+b2, B3: =A3+B3 and so on. I need only the row where a change
was made (A1, A2, A3, etc.) to caculate at the time of the change leaving the
other rows unchanged. What I am doing now is taking last weeks entry and
manually adding to the monthly total for each item. I sure hope someone can
help me with this, as I make mistakes adding.
--
Bill

take a look he

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

In article ,
"Bill" wrote:

I would like to know if it is possible to have a running total using only two
cells. I have many rows of items that are tracked each week and each item
rolls up to a monthly total. What I would like is to have the following: B1:
=A1+B1, B2: =A2+b2, B3: =A3+B3 and so on. I need only the row where a change
was made (A1, A2, A3, etc.) to caculate at the time of the change leaving the
other rows unchanged. What I am doing now is taking last weeks entry and
manually adding to the monthly total for each item. I sure hope someone can
help me with this, as I make mistakes adding.

Are you talking about the macro that performs the task or the "Worksheet
Function Accumulator." If you are talking about the latter, how do I keep the
whole sheet from calculating I make a change on the sheet? I could not get
the macro to work as written.
--
Bill


"JE McGimpsey" wrote:

take a look he

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

In article ,
"Bill" wrote:

I would like to know if it is possible to have a running total using only two
cells. I have many rows of items that are tracked each week and each item
rolls up to a monthly total. What I would like is to have the following: B1:
=A1+B1, B2: =A2+b2, B3: =A3+B3 and so on. I need only the row where a change
was made (A1, A2, A3, etc.) to caculate at the time of the change leaving the
other rows unchanged. What I am doing now is taking last weeks entry and
manually adding to the monthly total for each item. I sure hope someone can
help me with this, as I make mistakes adding.

In article ,
"Bill" wrote:

Are you talking about the macro that performs the task or the
"Worksheet Function Accumulator."

Both will work.

If you are talking about the latter, how do I keep the whole sheet
from calculating I make a change on the sheet? I could not get the
macro to work as written.

hard to tell - what does "I could not get the macro to work" mean? The
macro works fine for the example given. How did you modify it? Did you
put it in the worksheet code module?

I apologize, the macro does work. I made a stupid error.
Using the "Worksheet Function Accumulator" how do I keep the whole sheet
from calculating. If I change the data on selected row items, I do not want the remainder of the row items to change? I only want the selected row items to calculate when I change the data in column "A".

--
Bill


"JE McGimpsey" wrote:

In article ,
"Bill" wrote:

Are you talking about the macro that performs the task or the
"Worksheet Function Accumulator."

Both will work.

If you are talking about the latter, how do I keep the whole sheet
from calculating I make a change on the sheet? I could not get the
macro to work as written.

hard to tell - what does "I could not get the macro to work" mean? The
macro works fine for the example given. How did you modify it? Did you
put it in the worksheet code module?