I am working on a Schedule and I have a data base with a list of Names and another column with the weekends a person works for example ETW= every third weekend,EOW etc. I would like to transfer Names to another sheet so I would know under a specified date what people are scheduled that weekend.
I have played with advanced filtering but have not figured out a way to use multiple filters. Since on one specified weekend I may have all the ETW's working and on another weekend I may have all the EOW's working. Is there a way to do this. Or better yet what's the best/easiest way to do this? There would problably be about 4-6 different criteria for each weekend.
I have played with advanced filtering but have not figured out a way to use multiple filters. Since on one specified weekend I may have all the ETW's working and on another weekend I may have all the EOW's working. Is there a way to do this. Or better yet what's the best/easiest way to do this? There would problably be about 4-6 different criteria for each weekend.