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.
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