Comparing 2 tables

Hi,

Please see attached xls file.

On Sheet("Preliminary Exams"), I have 3 columns of data: Student's Name, Subject and Grade.

On Sheet("A Levels"), I also have the same 3 columns of data.

Would anyone be able to help me with a VBA script which will run through every data entry in Sheet("Preliminary Exams") and compare against the data in Sheet("A Levels"). Specifically,

If the Name, Subject and Grade are all identical, then this entry (all 3 columns) are copied to Sheet("Same");

If the Name is not found in Sheet("A Levels"), or the grade is different, then, copy that entry into Sheet("Different").

Please help. Thank you very much.

See attached file... I added macro 'Macro1'. I hope it's what you need.

Regards,
Antonio

Works beautifully. Thank you very much.

Glad to knoe it helped.

Regards,
Antonio