[SOLVED] How to create a column of items that matches a given criteria

[SOLVED] How to create a column of items that matches a given criteria

Hello!

I want to create a workbook where in Sheet1 I have details of students & in Sheet2 I want to record their marks. The point is as new students are added to Sheet1, their name should also get copied to corresponding class in Sheet2. Please see the attached workbook, there I have explained the issue in detail.

Thank you!