Forum Discussion
Solved
VBA to delete rows older than 14 days
Hello,
Who can help me with the following.
I have a list of users. New users are being added daily to the list. Old users that have been added 14 days ago must be deleted.
Is there some smart solution to delete these users by applying VBA code?
Kind regards,
Guram
(I don't do VBA) Assuming you run Excel 2021 or 365, an alternative:
in E4:
=FILTER(TableUsers, TableUsers[Date Added] >= TODAY()-14)
(I don't do VBA) Assuming you run Excel 2021 or 365, an alternative:
in E4:
=FILTER(TableUsers, TableUsers[Date Added] >= TODAY()-14)- Hello Lorenzo
Thank you for your efforts, but I need more like VBA solution to attach a button to it.
Best regards,
Guram
