Hello VBA friends
I'm learning VBA
I made this code that works fine, this code change the value in column A if there is a change in column C
Private Sub Worksheet_Change(ByVal Target As Range)
Dim i As Integer
If Not Intersect(Target, Range("C1:C5")) Is Nothing Then
For i = 1 To 5
Cells(i, 1).Value = Cells(i, 3).Value
Next i
End If
End Sub
but now i need to do vicevirce i mean i need also to change the value in column C if there is a change in column A
I was going to do onother event but is not possible
see attachmant
Thank you for your help
Bookmarks