Hi - I'm a Gifted Education teacher that takes small groups of students on a ton of different field trips throughout the school year. Not all of the kids attend all of the trips.
At the end of the year, I'd like to create a list for each individual student of the field trips they attended for the year. Short of copying and pasting, is there an easier way?
I was thinking if I could use a drop down list that contained all of the field trips and another that contained the students, I would select one student, then select only the trips they attended, in the end creating a list of the students name and the trips attended so I can print out.
Currently I have the kids names in Cells A3-A30, the trips in D1-DF1, and a "1" in the cell if that student attended that trip. Hope this makes sense......
At the end of the year, I'd like to create a list for each individual student of the field trips they attended for the year. Short of copying and pasting, is there an easier way?
I was thinking if I could use a drop down list that contained all of the field trips and another that contained the students, I would select one student, then select only the trips they attended, in the end creating a list of the students name and the trips attended so I can print out.
Currently I have the kids names in Cells A3-A30, the trips in D1-DF1, and a "1" in the cell if that student attended that trip. Hope this makes sense......