You need to tell us how the classes/students data is stored so we can help.
For instance is it tabular, like
Class A Class B Class C
Bill Joe Laura
Joe Laura Malcolm
Laura Malcolm Melanie
Pete Stuart Toni
etc.
or a list, like
Class Student
Class A Bill
Class A Joe
Class A Laura
Class A Pete
Class B Joe
Class B Laura
etc.
Any chance of posting the workbook?
Bookmarks