With a list of student names in first sheet in A1:A40

Sub NameWS()
'name sheets with list in Column A on first sheet
On Error Resume Next
For I = 2 To Worksheets.Count
Sheets(I).Name = Sheets(1).Cells(I, 1).Value
Next I
End Sub


Gord Dibben MS Excel MVP

On Fri, 1 Aug 2008 07:01:01 -0700, Frustrated Instructor <Frustrated
wrote:

I have created a grade book for the classes I teach at my local university. I
have been able to use many of the formula functions, etc. to automate much of
the calculation and compilation work I need to do to get grades out. I have a
tab for each student in a class. These worksheets auto populate the student's
information when I copy the list into the first worksheet.

With that as background, what I would like to have happen is for the tabs to
also auto populate the student's name on the tab, as each worksheet is an
individual student. Is there a way to set this up?

Don Goss
Frustrated Instructor