Deleting of rows for columns such as Time In, Employee, Occupation, Code Number, Department, and Favorite Food

[RobertRussell_Monsalud]

Good Day.

I am trying to delete the rows with the Time In (27/7/2022 4:01:00 pm onwards)?

This is the working file:
SampleExcelFile.xlsx (291.8 KB)

These are the rows that I am aiming to delete:

May I know the most efficient solution to automate this kind of process in a fast way? Thank you so much.

Best regards,
Robert

[vrdabberu (Varunraj Dabberu)]

Hi @RobertRussell_Monsalud

Check the below workflow:

Sequence16.xaml (11.6 KB)

Regards

[RobertRussell_Monsalud]

It worked. Thank you so much for your help. I really appreciate it.

Best regards,
Robert

[vrdabberu (Varunraj Dabberu)]

You’re welcome @RobertRussell_Monsalud

Happy Automation

[RobertRussell_Monsalud]

Hi @vrdabberu

May I know if the classic Excel activities can be used?

Thank you.

[vrdabberu (Varunraj Dabberu)]

Hi @RobertRussell_Monsalud

Classic activities can be used but Modern activities are the most efficient way to handle Filters. Since, Modern activities are in high demand. Try using Modern Excel activities.

Regards