Forum Discussion

Copper Contributor

Oct 26, 2020

Save Previous Cell Value Of A Changed Cell In Excel

I am trying to save the values of one column (G) to another (D) once I update it to a new value. I have the code correct, however the cell I want to save contains a formula and it is uploading th...

excel

Formulas and Functions

Macros and VBA

mtarler

Silver Contributor

Dec 31, 2020

dylanc09 sry, i thought you were going a different route.

You should be able to change the following lines in that code:

    Next J
    Set xDCell = Cells(xCell.Row, xCol)
    xDCell.Value = ""
    xDCell.Value = xDic.Items(I)
  Next

to this:

    Next J
    Set xDCell = Cells(xCell.Row, xCol)
    xDCell.Value = xDCell.Value + xDic.Items(I)
  Next

to make it do a running total.

dylanc09

Copper Contributor

Dec 31, 2020

mtarler

that did it!! thank you so much! you are an excel master! 🙂