Hello
I'm trying to use VBA to filter out anything older than today and then delete it. I'm having trouble filtering values earlier than today, i need the criteria1 to be earlier than today, but not a fixed date.
The code I am using is
Please Login or Register to view this content.
Last edited by Prototype0680; 03-27-2024 at 02:30 AM.
This is how you only delete tablerows (not the whole row).
It should fix your filtering problem too
Please Login or Register to view this content.
Try
Please Login or Register to view this content.
Thanks, it helps and works, but I faced the next problem while using it. Criteria 1 date is in text format. Is there any way i can convert it to a date?
Last edited by AliGW; 03-27-2024 at 02:32 AM. Reason: Please don't quote unnecessarily - use the Quick Reply button instead.
Assuming the dates are like that in the original post, I would probably add a column to the table to convert the date and filter on that.
Formula something likeFormula:
Please Login or Register to view this content.
It kinda works. I just need to delete extra column i added. Thank you!
Last edited by AliGW; 03-27-2024 at 02:31 AM. Reason: Please don't quote unnecessarily - use the Quick Reply button instead.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks