List of name without audiofilter

[schappelljr]

I am trying to make 4 lists. I want to list the names of people that worked on Monday ,Wednesday and Friday . The only way I know how to do it is to make 4 pivot tables. I just need name list in a column. The list will change from week to week. I'm cell referencing the names for something else so I can auto filter because it hides the blank cell and when the data changes the cell referencing get messed up.

what do u suggest?

 

[schappelljr]

I am trying to make 4 lists. I want to list the names of people that worked on Monday ,Wednesday and Friday . The only way I know how to do it is to make 4 pivot tables. I just need name list in a column. The list will change from week to week. I'm cell referencing the names for something else so I can auto filter because it hides the blank cell and when the data changes the cell referencing get messed up.

what do u suggest?


<a href="http://s7.photobucket.com/albums/y274/chappell21/?action=view&current=excel1.jpg" target="_blank"><img src="http://i7.photobucket.com/albums/y274/chappell21/excel1.jpg" border="0" alt="Photobucket"></a>

 

[Big Monkey]

May be less of a headache to create a small Access database and build some queries to get what you need.

 

[schappelljr]

I dont have access. I have everything else i just cant to this one part