hi fishermanryan, if Sheet1 has MBO_FFV_1 named range and Sheet2 MBO_FFV_2 named range, this works as expected
Sheet1 code:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim colNum As Long, rowNum As Long
If Not Intersect(Target, [MBO_FFV_1]) Is Nothing Then
Application.EnableEvents = False
[MBO_FFV_2].Value = [MBO_FFV_1].Value
End If
Application.EnableEvents = True
End Sub
Sheet2 code
Private Sub Worksheet_Change(ByVal Target As Range)
Dim colNum As Long, rowNum As Long
If Not Intersect(Target, [MBO_FFV_2]) Is Nothing Then
Application.EnableEvents = False
[MBO_FFV_1].Value = [MBO_FFV_2].Value
End If
Application.EnableEvents = True
End Sub
Bookmarks