Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do I auto name worksheets in Excel?
hi there
I want to auto name my worksheets in Excel. Eg: Name the first shet January, nrext sheet February, then have Excel auto name the remaining ten sheets with the remaining months of the year. This is similar to the auto fill function where cells can be filled automatically, but I cannot work out how to name worksheets this way. Does anyone know if this can be done, and if so, how? thanks Kathryn |
#2
|
|||
|
|||
I don't think there is a way to have Excel do this as part of the standard
functionality. You could do it with a macro though: Sub nmsht() Dim i As Integer On Error Resume Next For i = 1 To 12 Sheets(i).Name = MonthName(i) Next i On Error GoTo 0 End Sub Regards Rowan "Kathryn W" wrote: hi there I want to auto name my worksheets in Excel. Eg: Name the first shet January, nrext sheet February, then have Excel auto name the remaining ten sheets with the remaining months of the year. This is similar to the auto fill function where cells can be filled automatically, but I cannot work out how to name worksheets this way. Does anyone know if this can be done, and if so, how? thanks Kathryn |
#3
|
|||
|
|||
thanks very much Rowan
I'll give it a try cheers Kathryn "Rowan" wrote: I don't think there is a way to have Excel do this as part of the standard functionality. You could do it with a macro though: Sub nmsht() Dim i As Integer On Error Resume Next For i = 1 To 12 Sheets(i).Name = MonthName(i) Next i On Error GoTo 0 End Sub Regards Rowan "Kathryn W" wrote: hi there I want to auto name my worksheets in Excel. Eg: Name the first shet January, nrext sheet February, then have Excel auto name the remaining ten sheets with the remaining months of the year. This is similar to the auto fill function where cells can be filled automatically, but I cannot work out how to name worksheets this way. Does anyone know if this can be done, and if so, how? thanks Kathryn |
#4
|
|||
|
|||
You're welcome.
"Kathryn W" wrote: thanks very much Rowan I'll give it a try cheers Kathryn "Rowan" wrote: I don't think there is a way to have Excel do this as part of the standard functionality. You could do it with a macro though: Sub nmsht() Dim i As Integer On Error Resume Next For i = 1 To 12 Sheets(i).Name = MonthName(i) Next i On Error GoTo 0 End Sub Regards Rowan "Kathryn W" wrote: hi there I want to auto name my worksheets in Excel. Eg: Name the first shet January, nrext sheet February, then have Excel auto name the remaining ten sheets with the remaining months of the year. This is similar to the auto fill function where cells can be filled automatically, but I cannot work out how to name worksheets this way. Does anyone know if this can be done, and if so, how? thanks Kathryn |
#5
|
|||
|
|||
Hi
You can do it in some procedure, but likely during time you need to write the one, you can rename sheets in a lot of workbooks manually. When I'm wrong in this, then my next advice will be to create an empty worksheet with 12 renamed sheets (you also can enter all column headers and formulas, format cells, etc.), save it with some name like MonthsTemplate.xls, and whenever you need a new workbook, you open it and then save as with new name. -- Arvi Laanemets ( My real mail address: arvil<attarkon.ee ) "Kathryn W" <Kathryn wrote in message ... hi there I want to auto name my worksheets in Excel. Eg: Name the first shet January, nrext sheet February, then have Excel auto name the remaining ten sheets with the remaining months of the year. This is similar to the auto fill function where cells can be filled automatically, but I cannot work out how to name worksheets this way. Does anyone know if this can be done, and if so, how? thanks Kathryn |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I print all worksheets in Excel with one click? | New Users to Excel | |||
Excel needs to have the ability to insert "SUB" worksheets | Excel Worksheet Functions | |||
Sort rows across multiple worksheets - Excel 2003 | Excel Worksheet Functions | |||
How do I set Excel to auto open a document into a new Window even. | Excel Worksheet Functions | |||
excel links update not working in auto, calculations in auto | Excel Worksheet Functions |