Posts by LongSelong

Hello!

With the help of the function, data is loaded that is constantly (every minute) automatically changed in the "dynamic data" column. This data is updated in all rows at once.

My task:

If the value of B7 has changed since the last change, then we display the "name: Delta" in cell C7. If not, leave the cell C7 empty. The file have little example.

This VBA will be work for the rest of the rows below.

There are many such lines (more than 600)"

Unfortunately, I have a code that only works for one row and it does not accept changes via a function (because the data is passed from a third-party application via a function)

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count > 1 Then Exit Sub
If Not Intersect(Target, Range("B6")) Is Nothing Then
    If Range("B6").Value = Dynamic_data Then
        Range("C6").Value = ""
    Else
        Dynamic_data = Range("B6").Value
        Range("C6").Value = "Delta"
    End If
End If
End Sub