Excel Forum

Action Tracker

Ray Amaning-Agyarko

Active Member

Members

Forum Posts: 4

Member Since:
March 17, 2024

Offline

March 17, 2024 - 9:20 am

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.

See Answer

Charles Johnson

Borneo

Member

Members

Forum Posts: 41

Member Since:
April 25, 2020

Offline

March 17, 2024 - 10:39 pm

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.