Hi Guys,

I have this problem, I have two spreadsheets that I use with a list of students.

One spreadsheet has a list of students that have done Tuition courses.

The other spreadsheet has a list of students doing Revision only courses.

What I need is a routine that can check all those students that have studied a tuition course and are currently studying a revision course with us and remove those students from the Revision list, leaving only the students that have only done a revision course and not tuition. Is this possible?

I know this may involve a VB routine or a Macro. Any help offered would be great.

Column A has the student number, Col B has the student name and Col C has the subject they are studying.

Thanks