VBA Registers / Rosters

Carvell

New Member
Joined
May 21, 2016
Messages
17
Hello,
I have a table which tells me which class a student is in;

StudentGroup1Group2Group3Group4
StudentA2346
StudentB3417
StudentC6542
StudentD2371

<tbody>
</tbody>


I would like a VBA code which;

  1. Creates a list of students in each class from the table above
  2. Then copies each list onto a new worksheet and renames the tab to match the name of the class
  3. 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 nameTest result 1Test result 2Test result 3Test result 4Test result 5
A Jones3373726876
C Lewis 25538710062
B Smith1575646076
D Wotton4164908922

<colgroup><col><col span="5"></colgroup><tbody>
</tbody>

New student joins school;
Student nameTest result 1Test result 2Test result 3Test result 4Test result 5
A Jones3373726876
B Kane
C Lewis 25538710062
B Smith1575646076
D Wotton4164908922

<colgroup><col><col span="5"></colgroup><tbody>
</tbody>

Not sure if this is possible, please ask if something doesn't make sense

Thanks
Stuart
 

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

Forum statistics

Threads
1,213,536
Messages
6,114,207
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top