Additional help needed for adding separate accumulators for multiple cells

[russl722]

From thread: http://www.excelforum.com/excel-new-...ple-cells.html

jrambo63,

Try this code:

Please Login or Register  to view this content.

HTH,
Bernie
MS Excel MVP

I put this VB code into my Workbook and all of the cells that I want to accumulate are doing just that. But, I also want to link these cells to another workbook. When I go to put the formula to do this into the respective cells, the number updates, but the formula does not stay in the cell so the next time the number is changed in the other workbook it will update. What is going on? Is the VB code causing it to do this, and is there a way to fix it? Thank you. Hope I did this correctly now, I started a new thread as asked, I'm new at this and really appreciate all the help I have recieved so far.

[HaHoBe]

Hi, russl722,

this procedure is for updating values inside the cells:

Please Login or Register  to view this content.

Maybe you are looking for this which should leave any formula in the given range as is:

Please Login or Register  to view this content.

Ciao,
Holger

[russl722]

Holger,
Yes, thank you very much, now the formulas are staying in the cells. Thank you so much for your help!

russl722