Dear Team,
I am writing code for calculating my values. My code is
Code
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Sheets("Master data").Range("E4").Value = (250 - (Sheets("Master data").Range("T4").Value - Sheets("Master data").Range("L4").Value))
End Sub
This calculation to be continued for all the rows bellow from E4.
For example
E4= 250-(T4-L4)
E5= 250-(T5-L5)
E6 = 250-(T5-L5)
Like that this formula to be applied automatically for all the rows .
can any one help me to how to do this