Help Please !

[Wagg]

Help needed - I have NO idea what i'm doing!
I have made up a sheet and have a column of names on the front sheet.
each of the names link to separate worksheets.
I want the names to automatically update each of the sheets, 1 per name.
I have changed the code about 500 times and either it works once then stops, or just doesn't work.

the list of names will be changed on a regular basis so I was hoping if i just typed in the names, the tabs would change.

if some one could help with VERY simple explanation and language I would be really grateful.
cheers

 

[DebugGalpin]

Help needed - I have NO idea what i'm doing!
I have made up a sheet and have a column of names on the front sheet.
each of the names link to separate worksheets.
I want the names to automatically update each of the sheets, 1 per name.
I have changed the code about 500 times and either it works once then stops, or just doesn't work.

the list of names will be changed on a regular basis so I was hoping if i just typed in the names, the tabs would change.

if some one could help with VERY simple explanation and language I would be really grateful.
cheers

Just for clarity what are you actually looking to do with the list of names:-

Do you want the list of names to be the name of each of the sheets?
Or are they updating a cell within specific sheets?

 

[Wagg]

Just for clarity what are you actually looking to do with the list of names:-

Do you want the list of names to be the name of each of the sheets?
Or are they updating a cell within specific sheets?

Hmmmm.... Basically its a teacher reference. the list of names will have to be updated so I wanted the worksheet names to change when the name was changed, so I didnt have to search through sheets or add in names twice.

 

[VoG]

Something like this should work

Sub NameSheets()
Dim i As Long
For i = 2 To Worksheets.Count
    On Error Resume Next
    Worksheets(i).Name = Worksheets(1).Range("A" & i).Value
    On Error GoTo 0
Next i
End Sub