Renaming multiple existing sheets

willmark

New Member
Joined
Mar 7, 2014
Messages
3
I am a teacher who has created a gradebook in Excel. Each class has a student template sheet, individual sheets for each student in the class (maximum 26 students/class) which has the structure of the template and some cell referencing to the template, and a couple of mark-entry sheets and a sheet that shows the progress of all students in the class.

A number of teachers in the school have been using this gradebook and I am constantly looking for ways to make it more user-friendly. Currently, when a new course starts, a teacher opens a blank copy of the file (which has all of the sheets I mentioned above present). To set up a class, the teacher enters the students' names once on the mark entry sheet (called the "Binder Sheet"), and then changes the individual student tabs (right click...rename...) to reflect the names of their students.

I am wondering if there is a way to have the individual sheet tabs (Student 1, Student 2...Student 26) update automatically to match the names that the teacher enters on the Binder Sheet in cells A4:A29.

Any help is appreciated. VBA (which I don't know much about) is fine. I would like to be able to embed the update procedure/script into the blank template so that it is user friendly for others.

Thank you.

Mark
 

willmark

New Member
Joined
Mar 7, 2014
Messages
3
Thank you for responding so quickly. My minimal understanding of ABV is making it hard for me to recognize which parts of the code I should be editing to reflect the pre-existing names for each tab.
For example, my source data for the new names will be found on the "Binder Sheet". The student tab labels that I would like updated currently read "Student 1" through to "Student 26."
I do not need any sheets added or removed - for simplicity we just have a class set of 26 and teachers use as many as they need.

Thanks, ianccy
 

ianccy

Active Member
Joined
Jul 28, 2002
Messages
332
can send me a sample wb, i can try to help with my limit knowledge of vba, @@
 

willmark

New Member
Joined
Mar 7, 2014
Messages
3
Thank you, ianccy.

I have sent you a copy of the workbook. I hope it comes through ok.
 

Forum statistics

Threads
1,082,126
Messages
5,363,315
Members
400,725
Latest member
excelingtolearn

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top