I have a list of 100 students. Beside each student's name is his teacher's name.
There are 5 teachers.
20 students per teacher.
I would like to copy each student associated with each teacher to another worksheet.
Column A is the Student Name
Column B is the Teacher
Student Name Teacher
Joe Smith Mark Brown
Jane Doe Mark Brown
Mike James Mark Brown
Hopefully you get what I mean.
Bookmarks