Forum Discussion
School Presentation Day Data: Help save me endless hours of typing
I recently started working in a school and I'm finding our processes are a little dated. Presentation day prep for end of year is so huge and I spent days typing everything out last year, we need a b...
Thanks for your suggestion. I'm aware of how to mail merge as I use this often. Unfortunately MM won't solve this one as I need it to be smarter and turn the '1' in a particular column into a full title of the achievement.
One final tweak here. In so much as I'm still assuming you want to be able to print nice certificates of some kind on an individual basis. All of the results so far gave you the text for the citations, but all as a list of all the names......
Here's a variation--still using the formula that @Sergei Baklan first posted--that produces individual reports. You will need to use a drop-down box to select the name, and still do it one at a time, but it is, as the saying goes, "Suitable for Printing." And you can extend the database as much as desired; it should all grow and be handled by the formulas...
A PDF of the output, as well as the generating spreadsheet is attached.