I have a live input of numbers (from a live constantly changing source) say in cell A1 . Every time the number in A1 changes( it may be + or - but it will be different from the previous number), I want to add 1 in the cell B1( and keep adding in B1 as the live input keeps coming and changing in A1 ). can some one help?
Someone nice helped me with this formula….
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = Range("A1").Address Then
Range("B1").Value = Range("B1").Value + 1
End If
End Sub
The above formula is great but it works only if a data is directly inputted in the cell A1. If A1 = c1-d1 , then the values don’t change in B1 and in my case the live values are coming on cell C1 and D1 from where live difference is constantly updated in A1.
Please help me with a solution. Thanx !
Bookmarks