Possibly...
Private Sub Worksheet_Change(ByVal Target As Range)
Dim rg1 As Range, rg2 As Range, rg3 As Range
Set rg1 = Me.Range("a41:a56")
Set rg2 = rg1.Offset(20, 0)
Set rg3 = rg1.Offset(116, 0)
Application.EnableEvents = False
If Not Intersect(Target, rg1) Is Nothing Then
Target.Offset(20, 0) = Target
Target.Offset(116, 0) = Target
End If
If Not Intersect(Target, rg2) Is Nothing Then
Target.Offset(-20, 0) = Target
Target.Offset(96, 0) = Target
End If
If Not Intersect(Target, rg3) Is Nothing Then
Target.Offset(-116, 0) = Target
Target.Offset(-96, 0) = Target
End If
Application.EnableEvents = True
End Sub
Bookmarks