winninghkjc
New Member
- Joined
- Jul 21, 2016
- Messages
- 1
HI All,
Nice to meet you all. I am a study currently working as an assistant in an educational institution on a voluntary basis. I am going to consolidated the exam result of students and performing analysis.
The system we currently using is able to generate the result of each student as follow:
<tbody>
</tbody>
I have no idea that if there is any formula I can use / vba function can let me gather the data and copy them to the summary page?
<tbody>
</tbody>
Thank you for yours help and advice.
Many thanks,
jc.
Nice to meet you all. I am a study currently working as an assistant in an educational institution on a voluntary basis. I am going to consolidated the exam result of students and performing analysis.
The system we currently using is able to generate the result of each student as follow:
Name | Mary | |
Class | 1A | |
Computer | ||
Test | Assignment | Exam |
20 | 30 | 40 |
Music | ||
Test | Assignment | Exam |
40 | 50 | 60 |
Name | Peter | |
Class | 2A | |
History | ||
Test | Assignment | Exam |
50 | 30 | 20 |
Music | ||
Test | Assignment | Exam |
30 | 20 | 40 |
Language | ||
Test | Assignment | Exam |
30 | 50 | 70 |
<tbody>
</tbody>
I have no idea that if there is any formula I can use / vba function can let me gather the data and copy them to the summary page?
Computer | Music | History | Language | ||||||||||||||||
Name | Class | Test | Assignment | Exam | Test | Assignment | Exam | Test | Assignment | Exam | Test | Assignment | Exam | ||||||
<tbody>
</tbody>
Thank you for yours help and advice.
Many thanks,
jc.