Hello,
I have a table which tells me which class a student is in;
<tbody>
</tbody>
I would like a VBA code which;
In addition throughout the year some students leave and some join the school I would therefore like to be able to add or remove a student. I imagine I could do this by updating my table and re-running the code. However the marks a teacher has made in the row next to a student must stay with that student.
For example
<colgroup><col><col span="5"></colgroup><tbody>
</tbody>
New student joins school;
<colgroup><col><col span="5"></colgroup><tbody>
</tbody>
Not sure if this is possible, please ask if something doesn't make sense
Thanks
Stuart
I have a table which tells me which class a student is in;
Student | Group1 | Group2 | Group3 | Group4 |
StudentA | 2 | 3 | 4 | 6 |
StudentB | 3 | 4 | 1 | 7 |
StudentC | 6 | 5 | 4 | 2 |
StudentD | 2 | 3 | 7 | 1 |
<tbody>
</tbody>
I would like a VBA code which;
- Creates a list of students in each class from the table above
- Then copies each list onto a new worksheet and renames the tab to match the name of the class
- Each new worksheet created matches an original sheet as far as its design and formulas contained in it (I've not used VBA so not sure if this is possible?)
In addition throughout the year some students leave and some join the school I would therefore like to be able to add or remove a student. I imagine I could do this by updating my table and re-running the code. However the marks a teacher has made in the row next to a student must stay with that student.
For example
Student name | Test result 1 | Test result 2 | Test result 3 | Test result 4 | Test result 5 |
A Jones | 33 | 73 | 72 | 68 | 76 |
C Lewis | 25 | 53 | 87 | 100 | 62 |
B Smith | 15 | 75 | 64 | 60 | 76 |
D Wotton | 41 | 64 | 90 | 89 | 22 |
<colgroup><col><col span="5"></colgroup><tbody>
</tbody>
New student joins school;
Student name | Test result 1 | Test result 2 | Test result 3 | Test result 4 | Test result 5 |
A Jones | 33 | 73 | 72 | 68 | 76 |
B Kane | |||||
C Lewis | 25 | 53 | 87 | 100 | 62 |
B Smith | 15 | 75 | 64 | 60 | 76 |
D Wotton | 41 | 64 | 90 | 89 | 22 |
<colgroup><col><col span="5"></colgroup><tbody>
</tbody>
Not sure if this is possible, please ask if something doesn't make sense
Thanks
Stuart