Forum Discussion

Shelbie1288's avatar
Shelbie1288
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
formulB's avatar
formulB
Copper Contributor
Nov 23, 2022

mtarler I'm trying to do a similar thing to the original poster, and your answer seems to be the best resolution. I have basically no experience with VBA but need the source column to be H and the Target column to be AA. What specifically would I need to change in the script to make it run correctly?

mtarler's avatar
mtarler
Silver Contributor
Nov 23, 2022

formulB In my answer above on lines 5 & 6 I have:

Const xSource = "G:G, L:L"  'This is a list of columns that need to be saved
Const xTarget = "D:D, H:H"  'This is a matching list of columns where to save

So change to

Const xSource = "H:H"  'This is a list of columns that need to be saved
Const xTarget = "AA:AA"  'This is a matching list of columns where to save

 

  • formulB's avatar
    formulB
    Copper Contributor
    Jan 13, 2023

    mtarler this has all worked brilliantly for the last few weeks but I'm now getting an issue where the changelog column doesn't register a change if a value is copied and pasted in. It only seems to work if you manually type in the change.

     

    Is there a way to fix this?

Resources