Change the VBA code and transferred from paper to another

Assalamo Alykom... for Worksheet 1, you need to set it up as in the example. Once it is like that, you can use a filter to show the name of the student and the test results you want.

For Worksheet 2, please describe it (in Arabic) here what you are trying to accomplish. Also, show a before and after example so that I can understand the problem.

abousetta