Using filters for a scheduling worksheet
I am trying to use advanced filtering and whatever else I need to make this work. I have a list of names that are scheduled on various days of the week. I need to be able to see this in multiple ways and have the views easily changed for lay users. First I need to see a list of all the available staff and all the possible shifts (col A). Unfilterd view.
2nd I need to be able to see only the people scheduled on Say Monday - that I have accomplished by an easy drop down filter by the day - but the other days then do not show people if they are not schedule for that day. But then as an overall I want to be able to EVERYONE who is on ANY schedule for the week. This will give me a list of all schedule people. Basically I need to each day filter out the blanks when I want a daily view - and then when I want the week view I need to filter out only Everything blank. Here is my list of data - when the overall filter is working, I should not be seeing sam. I hope this makes sense. Name DEPARTMENT Sunday Monday Tuesday Wednesday Sched Arrived MON Sch Arrived Sched Arrived Sched Arrived John INBOUND IN-1 Jane OUTBOUND OUT-1 OUT-1 OUT-1 Sally OUTBOUNDOUT-1 OUT-1 OUT-1 Dick OUTBOUNDOUT-1 Spot OUTBOUND OUT-1 OUT-1 Sam OUTBOUND Suzie OUTBOUND OUT-1 OUT-1 George OUTBOUND OUT-2 OUT-2 OUT-2 |
All times are GMT +1. The time now is 10:37 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com