Hi All,
I have a sheet with names and other personal information from columns B-M.
I have dates for each day from rows N-JA.
What I want is to be able to set up a filter that will show if a non-blank value shows up in a certain date range.
Example: for June 15-August 1 I want to filter if any row within that date range.
So if employee 1 is scheduled to work on any of those days he/she will be shown.
I have a sheet with names and other personal information from columns B-M.
I have dates for each day from rows N-JA.
What I want is to be able to set up a filter that will show if a non-blank value shows up in a certain date range.
Example: for June 15-August 1 I want to filter if any row within that date range.
So if employee 1 is scheduled to work on any of those days he/she will be shown.