Delete rows which are before some date

[sonaliaggarwal47 (Sonali Aggarwal)]

Hi @Life_Hacks,

Please refer steps mentioned in below post:

How to delete particular row in excel

HI @Baby123 Try like this Use Excel Application and read range activity and store the value in the datatable Use Filter Datatable activity and configure it. [image] Use write range and give the new sheet name and check on add headers in properties and write the data table in the new sheet. Delete the old sheet using modern activity(Find the activity after enabling show modern in the filters) [image] Or you can use that sheet as the initial inout with no changes Hope this Help…

In the filters, you. A provide conditions for the month to keep/delete certain rows.

Regards
Sonali