Hi All,
Trying to do a Macro (I think that's the correct terminology) but it comes up with 'Target.Column <Object Required>
Trying to do a Macro (I think that's the correct terminology) but it comes up with 'Target.Column <Object Required>
VBA Code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 2 And Target.Cells.Count = 1 Then
If LCase(Target.Value) = "male" Then
With Target.EntireRow
.Copy Sheets("Males").Range("A" & Rows.Count).End(xlUp).Offset(1, 0)
.Delete
End With
If LCase(Target.Value) = "female" Then
With Target.EntireRow
.Copy Sheets("Females").Range("A" & Rows.Count).End(x1Up).Offset(1, 0)
.Delete
End With
End If
End If
End Sub
Last edited by a moderator: