I'm a beginner at using drop-down menus in sheets. I have a sheet that lists students' names down in rows and their attendance for the semester across the columns.
Is it possible to create a drop-down menu that would:
- allow me to choose between all of my students?
- report only certain ranges of his/her attendance, say, one month at a time?
- allow me to print off those attendance "progress reports?"

Is there an easier way?

Thanks.