How do I sequentially number indvidual worksheets?
I want to have a job sheet that each time I open a new document the number
changes by +1 automatically? |
How do I sequentially number indvidual worksheets?
Hi,
Have a look here http://www.mcgimpsey.com/excel/udfs/sequentialnums.html Mike "Soo" wrote: I want to have a job sheet that each time I open a new document the number changes by +1 automatically? |
How do I sequentially number indvidual worksheets?
Are we talking worksheets or workbooks? When you open a new document you
want what to increment by 1? Since the default name of a workbook is always Book1... what would be the point of renaming it to Book4 or whatever since you generally wouldn't call a workbook by that name anyway? It is not at all clear what you want to renumber or when you want to renumber them? Suppose I open a workbook to look at it, not to change it, do you really want to insert a new sheet and rename it? Besides sheets are automatically incremented when you insert them. Although those names, Sheet1, Sheet2,... are rather useless. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Soo" wrote: I want to have a job sheet that each time I open a new document the number changes by +1 automatically? |
All times are GMT +1. The time now is 12:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com