Hi,

Am Thu, 1 Feb 2018 17:30:10 -0600 schrieb leonard hofstatder:

Thanks, Claus - using starter 2010, VBA is not available. I made a
workaround by just making another table and just shading the cells for
each corresponding day. It serves my purpose.

filter the range E4:G176 by contains "M" for Monday and copy the
filtered list to the expected sheet. Repeat this for all your days.


Regards
Claus B.
--
Windows10
Office 2016