Generate a list based on meeting certain criteria.

SO here is my problem i have list of students who are signed up for certain courses. Each day there are two sessions (1 and 2), for a total of ten days and sessions combined.

What i need to be able to create attendance sheets based on the classes that the kids have signed up for. I want to be able to select from the drop down menus and then have the lists automatically populated. I would also like the cells to have a border put around them so i can use them as the weekly attendance sheet. I think that is done with conditional formatting and i may have that part figured out but i cannot figure out how to get the lists to populate.

Thanks in advance for any help you gurus are able to give.

I have attached a sample sheet.

Los

Here is a sample of what i am looking for.....

The attendance sheet auto populates with the students signed up for each class.

Thank you for the reply, apparently the file i attached lost the third drop down menu for the course selection. So i have reattached the most up to date sheet. So now it will only return those students who are signed up for Monday, session 1, homework help 1-3 or any combination of the day, session and course.

There is no table which identifies a class attendance: there are only sessions so by default any class selected for Monday Session ! will give the results I provided.

would there be any way to get these results?

How about with this one???

If the all people in a given session do NOT attend ALL classes for that session, then you need a "Class within Session"" enrolment list.

See attached.

So i am at a loss as to how i could make this work. How could i manipulate the data to get the tired results, I'm not sure what you mean by "class within session"

I think What you did worked.... Thank you SOOOOOO much you were a great help

See the latest posting: you provided the answer in your posting when replaced the "X" with Class title!!!!!

Team effort!

If you are happy with the results, please mark thread as SOLVED.