| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Name the worksheet by a formula
Hi, I need to name 31 worksheets as "1-Jul", "2-Jul", "3-Jul"...... 31-Jul.
Can Excel automatically name the worksheets by a formula which i set in a certain cell? Thanks for your help. =) |
|
#2
|
|||
|
|||
|
You can use a macro similar to:
For i = 1 To 31 Sheets(i).Name = i & "-Jul" Next It will name the first 31 sheets as you desire. You can create something similar to name them based upon your cell value. -- Damon Longworth Don't miss out on the 2005 Excel User Conference Sept 16th and 17th Stockyards Hotel - Ft. Worth, Texas www.ExcelUserConference.com "annie" <annie@^^ wrote in message ... Hi, I need to name 31 worksheets as "1-Jul", "2-Jul", "3-Jul"...... 31-Jul. Can Excel automatically name the worksheets by a formula which i set in a certain cell? Thanks for your help. =) |
|
#3
|
|||
|
|||
|
Thanks Damon!
"Damon Longworth" ¦b¶l¥ó ¤¤¼¶¼g... You can use a macro similar to: For i = 1 To 31 Sheets(i).Name = i & "-Jul" Next It will name the first 31 sheets as you desire. You can create something similar to name them based upon your cell value. -- Damon Longworth Don't miss out on the 2005 Excel User Conference Sept 16th and 17th Stockyards Hotel - Ft. Worth, Texas www.ExcelUserConference.com "annie" <annie@^^ wrote in message ... Hi, I need to name 31 worksheets as "1-Jul", "2-Jul", "3-Jul"...... 31-Jul. Can Excel automatically name the worksheets by a formula which i set in a certain cell? Thanks for your help. =) |
|
#4
|
|||
|
|||
|
Hi Annie,
I would suggest you name your sheets with numbers instead of month names. For dates format them like year-month-day to allow you to sort your worksheets by name. Same applies to filenames in a directory. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "annie" <annie@^^ wrote in message ... Thanks Damon! "Damon Longworth" ¦b¶l¥ó ¤¤¼¶¼g... You can use a macro similar to: For i = 1 To 31 Sheets(i).Name = i & "-Jul" Next It will name the first 31 sheets as you desire. You can create something similar to name them based upon your cell value. -- Damon Longworth Don't miss out on the 2005 Excel User Conference Sept 16th and 17th Stockyards Hotel - Ft. Worth, Texas www.ExcelUserConference.com "annie" <annie@^^ wrote in message ... Hi, I need to name 31 worksheets as "1-Jul", "2-Jul", "3-Jul"...... 31-Jul. Can Excel automatically name the worksheets by a formula which i set in a certain cell? Thanks for your help. =) |
|
#5
|
|||
|
|||
|
I see. Thanks David! =)
"David McRitchie" ¦b¶l¥ó ¤¤¼¶¼g... Hi Annie, I would suggest you name your sheets with numbers instead of month names. For dates format them like year-month-day to allow you to sort your worksheets by name. Same applies to filenames in a directory. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "annie" <annie@^^ wrote in message ... Thanks Damon! "Damon Longworth" ¦b¶l¥ó ¤¤¼¶¼g... You can use a macro similar to: For i = 1 To 31 Sheets(i).Name = i & "-Jul" Next It will name the first 31 sheets as you desire. You can create something similar to name them based upon your cell value. -- Damon Longworth Don't miss out on the 2005 Excel User Conference Sept 16th and 17th Stockyards Hotel - Ft. Worth, Texas www.ExcelUserConference.com "annie" <annie@^^ wrote in message ... Hi, I need to name 31 worksheets as "1-Jul", "2-Jul", "3-Jul"...... 31-Jul. Can Excel automatically name the worksheets by a formula which i set in a certain cell? Thanks for your help. =) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cannat paste that macro formula onto a worksheet | Excel Discussion (Misc queries) | |||
| How do I make formula in Excel from other worksheet? | Excel Worksheet Functions | |||
| Worksheet references another tab in formula | Excel Worksheet Functions | |||
| How do I copy formula cells from one worksheet to another? | Excel Worksheet Functions | |||
| Can I use a formula to get the worksheet name into a cell? | Excel Worksheet Functions | |||
Hybrid Mode
