How to remove data from data table


Templates.xlsx (15.9 KB)

i want to delete the details of employee whose total duration is “0” without using filter table activity or delete table activity can anyone help me out


You can run this macro:

Sub deleteRows()
Dim pattern As String
Dim j As Integer
j = 9
pattern = “0”
RowCount = ActiveSheet.UsedRange.Rows.Count
Dim i As Integer

For i = 1 To RowCount
'MsgBox Cells(i, j)
If Cells(i, j) = pattern Then
Cells(i, j).EntireRow.Delete
i = i - 1
RowCount = RowCount - 1
End If
Next i
End Sub

Please set the pattern and column number according to your requirement.