| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Numbering Worksheets
I need to know how to number worksheets so everytime I save as and open a new
one the next number automatically comes up. For example: I want to star the first worksheet with CBKI001 And I want that when I save it and open a new one it reads CBKI002. I want this to happen only if I save it not if it is opened and not saved. Is this even possible? -- Jheison |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Numbering Worksheets
Hi,
This must be a contender for the most often asked question and most respondents direct people here http://www.mcgimpsey.com/excel/udfs/sequentialnums.html Mike "jheison" wrote: I need to know how to number worksheets so everytime I save as and open a new one the next number automatically comes up. For example: I want to star the first worksheet with CBKI001 And I want that when I save it and open a new one it reads CBKI002. I want this to happen only if I save it not if it is opened and not saved. Is this even possible? -- Jheison |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| consecutive numbering on multiple worksheets | Excel Discussion (Misc queries) | |||
| sequential numbering across multiple worksheets | Excel Worksheet Functions | |||
| Numbering Worksheets | Excel Discussion (Misc queries) | |||
| Copying and numbering worksheets | Excel Discussion (Misc queries) | |||
| Auto page numbering for several worksheets | Excel Worksheet Functions | |||
Hybrid Mode
