VBA - Copy/Paste Value formula result in adjacent cell in row

[povictory]

Hi - I'm not strong in VBA and haven't been able to find a similar thread with a helpful answer to get to my result.

I have a spreadsheet with data in columns O through Z. When those columns are updated, a formula in column K updates to a new value. My desired outcome is that I'd like for that updated value in column K to immediately be hardcoded into column L whenever the value in column K updates, as a result of new inputs in O:Z. I would like this to apply to multiple rows in the spreadsheet, let's say row 7 through 107.

Any assistance on code that would do this would be greatly appreciated!

 

[Engberg]

Something like this then? This looks at all values in K7-107 and puts them in L7-107 whenever there is a change on the sheet. This needs to be placed in the sheet specific VBA module.

Private Sub Worksheet_Change(ByVal Target As Range)
    Application.EnableEvents = False
    Range("L7:L107").Value = Range("K7:K107").Value
    Application.EnableEvents = True
End Sub

 

[povictory]

Something like this then? This looks at all values in K7-107 and puts them in L7-107 whenever there is a change on the sheet. This needs to be placed in the sheet specific VBA module.

Private Sub Worksheet_Change(ByVal Target As Range)
    Application.EnableEvents = False
    Range("L7:L107").Value = Range("K7:K107").Value
    Application.EnableEvents = True
End Sub

Exactly what I was looking for...thank you!!