|
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. =) |
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. =) |
Thanks Damon!
"Damon Longworth" 在郵件 中撰寫... 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. =) |
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" 在郵件 中撰寫... 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. =) |
I see. Thanks David! =)
"David McRitchie" 在郵件 中撰寫... 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" 在郵件 中撰寫... 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. =) |
| All times are GMT +1. The time now is 03:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com