Hi Everyone!

I am wondering if it is possible to take a database of behavior referrals (submitted via googleforms) and program a macro to automatically generate a detention list. Is this something that is only possible by using access or can excel do it too? Is it possible to sort the detention list by homeroom teacher (ie. look at the fields and put everyone in Ms. A's homeroom in one section of the list and everyone in Ms. B's homeroom in a different section)?

Thank you for your help!