Hi CedarLake23,
A possible VBA solution
Sub Delete_D_or_R_Example()
Dim Firstrow As Long
Dim Lastrow As Long
Dim Lrow As Long
With ActiveSheet
Firstrow = .UsedRange.Cells(2).Row
Lastrow = .UsedRange.Rows(.UsedRange.Rows.Count).Row
For Lrow = Lastrow To Firstrow Step -1
With .Cells(Lrow, "B")
If Not IsError(.Value) Then
If Left(.Value, 1) = "R" Or Left(.Value, 1) = "D" Then .EntireRow.Delete
End If
End With
Next Lrow
End With
End Sub
The above assumes that your Employee ID is in Column B. Change the line
to whatever column you IDs are in
Bookmarks