Help Creating a Detention List

[Xanbcoo]

Hi, I'm a teacher and I need some help making a weekly detention list in excel.

I'd like to have the first sheet be the final list of students. This will change every week.

The second sheet is a list of students organized by homeroom teacher. There is a column for a yes/no response to whether or not they had their detention slip signed by a parent. I figured out how to make a drop-down box of "yes" or "no" by myself.

I need help getting the "yes" students to appear on the first page. What do I use to do this? If there is an easy tutorial for this kind of job a link would be great.

Thanks.

[newdoverman]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[JO505]

Does this help?

[Xanbcoo]

YES! Just like that. That is excellent, thank you so much.

[Xanbcoo]

Can I ask, is there a way to have it indicate that a student was issued a detention form but has not returned the signed form by a parent?

[JO505]

Just add a column in the data table.

Jim O

[JO505]

Oops. I am not used to this new look, I could not see if the file was attached.

Lets try this again.

Jim O

[Xanbcoo]

That's amazing. Thank you so much. This makes my life easier.

[JO505]

If you are happy with the result be sure to mark the thread as solved.

Jim O