Hello Everyone,
I want to write macro that will change one cell value to 0 when I will have "YES" in another cell. I found code that almost fits my purpose:
Private Sub worksheet_change(ByVal target As Range)
If Range("b3").Value = "DN" Then
Range("C3:C5").Value = 0
End If
End Sub
problem is that I want it to work not only in that one cell but on the cells below as well. Also I want it to change value to previous one if the value of that other cell will be "NO" or blank.
Can you help? Anyone?
Kind regards,
Daniel
Bookmarks