Hi all.

I have a wee rota that i have created for work and was wondering if th
following 'problem/query' is possible.

My rota is set up with 8 coulmns: Employee Name is one, the other
columns are headed Sunday to Monday.

I have 30 staff - not all staff work the same shifts or same days eac
week.

What i am wanting to do, is,using the Data| Filter | Advance Filte
command, filter all staff who are working on the monday from th
'Weekly Rota' (sheet 1 ) to a daily rota (sheet 2). At the moment
have been doing it by selecting the Monday column, selecting 'No
Blanks' on the filter command, and then filtering the Column over t
Sheet 2. This all works fine, but I am trying to find out whether it i
possible to filter all the shifts for a certain day, ALONG with th
staff names of the people who are only working that day. This i
proving to be somewhat difficult and i have been looking at doing thi
for a few weeks now and am not having much luck.

Can someone please put me out of my misery and tell me if this i
possible?

Any help would be very very much appreciated

--
Message posted from http://www.ExcelForum.com