how to delete rows with the date in excel
Actually I am in progress of deleting past 7 days record in excel sheet with date may i know how to get the date and delete past 7 days in automation anywhere when i try to delete without loop it just delete 1 record when with in the loop it just delete all the record
how to delete rows with the date in excel
Actually I am in progress of deleting past 7 days record in excel sheet with date may i know how to get the date and delete past 7 days in automation anywhere when i try to delete without loop it just delete 1 record when with in the loop it just delete all the record
Hey
You can use Datetime:Substract, pass system date, then you can compare it with the excel date.
Thanks for the reply when i have done this all that you said but i have a problem in when it delete the 5 row the 6 row place it in 5 row so it was not deleting the row properly what should i do now
kindly help me in this
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.