name of sheet

[Maria]

How do I create a link so that the name of my sheet is equal to data in a
cell? Currently I am re-naming each sheet tab, there has to be an easier way?

Thank you

 

[Bob Phillips]

You need VBA

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
If Target.Address = "$A$1" Then
Sh.Name = Target.Value
End If
End Sub

put the code in the ThisWorkbook code module.

--

HTH

RP
(remove nothere from the email address if mailing direct)