Hello,
I need help with the following codes. I have 8 cells named "ChangeCell" and changing each one will trigger a different copy paste. It works now when changing one cell either manually or through copy & paste but I need this to be more flexible to allow the user to copy paste multiple cells at once (any number of cells within the ChangeCell range will trigger it and all of them need to be updated)
thanks!PHP Code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Application.Intersect(Target, Range("ChangeCell")) Is Nothing Then
If Target.Address = "$AI$8" Then
Range("AE9").Value = Target.Offset(, 1).Value
End If
If Target.Address = "$AI$9" Then
Range("AE10").Value = Target.Offset(, 1).Value
End If
If Target.Address = "$AI$10" Then
Range("AE15").Value = Target.Offset(, 1).Value
End If
If Target.Address = "$AI$16" Then
Range("AE16").Value = Target.Offset(, 1).Value
End If
If Target.Address = "$AI$11" Then
Range("AE8").Value = Target.Offset(, 1).Value
End If
If Target.Address = "$AI$13" Then
Range("AE17").Value = Target.Offset(, 1).Value
End If
If Target.Address = "$AI$14" Then
Range("AE19").Value = Target.Offset(, 1).Value
End If
If Target.Address = "$AI$15" Then
Range("AE18").Value = Target.Offset(, 1).Value
End If
End If
Application.EnableEvents = True
End Sub
Bookmarks