Forum Discussion
Guram_Bregadze
Dec 22, 2022Copper Contributor
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 sma...
- Dec 22, 2022
(I don't do VBA) Assuming you run Excel 2021 or 365, an alternative:
in E4:
=FILTER(TableUsers, TableUsers[Date Added] >= TODAY()-14)
Lorenzo
Dec 22, 2022Silver Contributor
(I don't do VBA) Assuming you run Excel 2021 or 365, an alternative:
in E4:
=FILTER(TableUsers, TableUsers[Date Added] >= TODAY()-14)
Guram_Bregadze
Dec 23, 2022Copper Contributor
Hello Lorenzo
Thank you for your efforts, but I need more like VBA solution to attach a button to it.
Best regards,
Guram
Thank you for your efforts, but I need more like VBA solution to attach a button to it.
Best regards,
Guram