| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Increment sheet names
I need to add a new sheet to a file every week; that new
sheet name becomes Wk 39, the previous sheet was Wk 38, for all 52 weeks. Is there a way to automatically label the new sheet to the new week number? I've been trying to come up with code to do this for awhile, but I'll admit defeat at this point. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy formula - keep cell same but increment sheet numbers | Excel Discussion (Misc queries) | |||
| Linked Cells, Increment Sheet Number Ref. | Excel Discussion (Misc queries) | |||
| change formula- keep cell increment sheet numbers | Excel Discussion (Misc queries) | |||
| Formula copy paste down in a sheet but change row letter increment | Excel Discussion (Misc queries) | |||
| Automatic cell increment with data from sheet 1 to sheet 2 | Excel Worksheet Functions | |||
![Eva Shanley[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
