Filtering a Data Base

[TWK]

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.

 

[The Tamer]

Hi TWK, nice to meet you!

Can you post an example of how your data looks at the moment, and how it should look when it's finished?

To paste sections of worksheets onto this board you need to download HTML Maker (here: www.puremis.net/excel/downloads.shtml )
Instructions to use it are here: www.mrexcel.com/board2/viewtopic.php?t=92622
And an update you’ll need to read before you use it is here: www.mrexcel.com/board2/viewtopic.php?t=131105

Good luck.

Tamer

 

[TWK]

Hi Tamer,Nice to meet you also.
Unfortunately from my computer at work I am pretty limited as to what I can download from the net.
I can try to show you like this: Basically I would like it to recognize when I tell it on 2/20 all EOWA,ETW and ETWB are working that it would put all the names down that corrospond to those weekend rotations under that date.

Name l Weekend
Davis EOWA
Smith ETW
Jones Sundays
Allen EOWB
New Sheet
2/20/05 l 2/26/05 l 2/27/05 l 3/5/05 l 3/6/05
Davis Allen Davis johnson
jones Smith Smith krause

 

[TWK]

Sorry it looked much better before I posted it.

The New Sheets names should be under each date. Each date would be a seperate column.

My intent is to be able to track what weekends people are working and to be able to make changes on the master data base that will be reflected on the other sheet. For example if someone was working every other weekend and then changed to Every third weekend, I could change this on the master and the other sheet would automatically update.


Thank You in advance.