Well this code does exactly the same as the 5-page lines of code you hade.
The only thing you need to do is rename the week sheets, Monday through Friday (withou the numbers to Monday (1) .... Friday (1) (notice the blank between the weekday and the first (
the code is this
This does not do anything new like keeping duplicates it's just you macro made efficient and.. I am still waiting for the answer to my question
IMPORTANT: insert a new VBA module and make sure the macros are Public (move the ClearFilter_Click macro to this project and make it public too)
Bookmarks