Forum Discussion

Markd68's avatar
Markd68
Copper Contributor
Jan 05, 2022

update cell when value changes but retain original value in cell above

Hi everyone I have a spreadsheet where I record the value of variations but this value might change from month to month, what I want to do is the following: (please see screen shots below, I can also send spreadsheet if required)

If a value is entered into a cell  in cell J10 then the value of cell L99 would be returned to cell K10. Then if another value is entered into J10 then the value of cell L99 would be returned to cell K11. but the original value of L99 that was returned originally to Cell K10 remains if the Value of cell L99 changes. this would then flow on to the proceeding cells in row K as the value of cell 99 changes

 

Thanks in advance

excel
Macros and VBA

1 Reply

  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor
    Jan 07, 2022

    Markd68 

    If I can recommend you, include your Excel version, operating system, storage medium (hard drive, OneDrive, Sharepoint, etc.), sample file (without sensitive data), and a bit of context (as you have already done) to help others answer your question.

    Describe your project based on the inserted file.

    In your current description, the connection between the cells is incomprehensible to me.

    It could be done with VBA code or formulas as I suspect, but without the information one can only guess.

     

    Private Sub Worksheet_Activate()
Worksheets("Consultant").Range("L99").Value = Worksheets("Project").Range("K10").Value
End Sub

     

     

    Thank you for your understanding and patience

     

    NikolinoDE

    I know I don't know anything (Socrates)

Resources