In the line of code below in the "Workbook_Open" Event you need to try changing the "VbMonday" (IN RED) to "VbSunday"
This gives you the start of the week. I think that is your problem.
Ref :- Filter
In the lookuplist, i added more employees, and they come from different department. Can I have a filter button in cell A3 to show employees from departments?
Can you explain how you want this to work, for example do you want it on each sheet on just "LookUpList"
An Example of what it will show/do would help.
I can't get a feel for what you expect to see and where !!!
All the other things I have done.
Bookmarks