Numbering Worksheets

J

jheison

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do you set a cell to increase numerical sequence? 2
Invoice Numbers 1
When you hit Save on a template, how can you save as worksheet? 1
Worksheets 2
numbering pages in footer 1
excel opening view help needed 0
How do I save only active worksheet without save all of worksheet 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0

Top