Hi, I already have a VBA code to automatically move people from one tab to another
I understand I cannot have more than one of these at a time, but I would like to also restrict anyone from copying and pasting into my columns that contain a drop down list, is this possible please
VBA Code:
Private Sub Worksheet_Change(ByVal Target As Range)
Application.ScreenUpdating = False
If Intersect(Target, Range("G:G")) Is Nothing Then Exit Sub
On Error GoTo endit
Application.EnableEvents = False
If Target.Value = "Band 7's" Then
Target.EntireRow.Copy Worksheets("Band 7's").Cells(Rows.Count, 1).End(xlUp).Offset(1, 0)
Target.EntireRow.Delete
ElseIf Target.Value = "D2A Awaiting QA" Then
Target.EntireRow.Copy Worksheets("D2A NNA").Cells(Rows.Count, 1).End(xlUp).Offset(1, 0)
Target.EntireRow.Delete
End If
endit:
Application.EnableEvents = True
Application.ScreenUpdating = True
End Sub
I understand I cannot have more than one of these at a time, but I would like to also restrict anyone from copying and pasting into my columns that contain a drop down list, is this possible please