Dear experts,

I have cell E2 which is calculating value every minute. My sheet is updating data from internet therefore I have formula =countif() formula in E2 to calculate a certain value. I want updated value in E2 to be save in D1 , D2 , D3 as it changes

like if E2 is 10 than store 10 in D1, if E2 changes to 20 then store it in D2 and so ON. i have a working code

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address <> "$E$2" Then Exit Sub 'Only interested in cell E2
Range("D65536").End(xlUp).Offset(1, 0).Value = Target
End Sub

this code only work if I enter data manually in E2, but does not work if there is a formula in cell E2

Look forward to hear from seniors soon.
Regards
Muhammad Ali