I have an Excel sheet on my PC that contains macros. I want to use this sheet to track assigned actions. my sheet has five tabs (All, Open, Due, and Completed). I want the All tab to clear all filters and show all actions, I also want the Open tab to filter all actions with dates in the due dates or and revised dates column ahead of the current date. The Due tab should also filter all actions that have dates in the due date or and revised dates column behind the current date, and finally, the Completed tab to filter actions with a completed column filled irrespective of what date is in the due and revised date column.
I do not fully understand your logic. Surely, if an Action is "Closed" then it cannot be "Open" or "Due", so should not be visible when filtering for those criteria.
Also, you are using before current date for Open and after current date for Due. What if Due Date is the same as the current date? Surely it should be before or equal to for Open and after or equal to for Due.
Attached is your file with new code. I have renamed the buttons (btnAll, btnOpen, btnDue & btnClosed). the code assigned to each is in the Action Log" worksheet Object Module.
I have implemented the logic observations mentioned above in the code.
Hi Charles,
Thanks for the feedback. However, I am having difficulty accessing your file to test your codes. Any help?
Thanks,
Ray.
Try right-clicking on the file and "Download linked file as...".
Thanks, Riny. It worked.
@Charles Johnson Thanks very much. I tried your code and it worked very fine. I really appreciate.
