Ask Experts Questions for FREE Help !
Ask
    mrohner559's Avatar
    mrohner559 Posts: 1, Reputation: 1
    New Member
     
    #1

    Mar 8, 2012, 12:30 PM
    Auto numbering in excel
    I would like to automtically number individual sheets ie: 12-0001, 12-0002, etc. Can I do that in excel?
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
     
    #2

    Mar 9, 2012, 09:03 AM
    The only way to "automatically" name worksheets is with VBA. Can you provide more information about what you mean?

Not your question? Ask your question View similar questions

 

Add your answer here.


Check out some similar questions!

Sequential numbering in Excel [ 3 Answers ]

Hi, I'm trying to number a column in sequential order by counting the number of times a certain word is typed in another range. For example: AAA 1 BBB 1 AAA 2 AAA 3 CCC 1 I need the numbers to be in sequence in column B:B every time a word is typed multiple times in column A:A.

Sequential numbering in excel 2007? [ 3 Answers ]

Sequential Numbering in Excel Sheets. Sheet 1 - Copy to Sheet 2 But No in Cell "A1" must Change to next No i.e 0001 to 0002.

Auto Sequential Numbering [ 3 Answers ]

Is there a way within Excel to Auto Generate a new number every time I open a spreadsheet.ie: I made a Purcahse Order template and I would like for Excel to generate a new Purchase Order number whenever I open it up. Can anyone let me know if this is a possibility.

Microsoft Excel Automatic Numbering [ 3 Answers ]

I have an existing excel spreadsheet, & I want to go back in, create another column, & automatically number it, starting at 1 & going on sequentially. According to the help, I started the numbering, 1,2,3 & used the FILL command (down). It then changes all the highlighted cells to 1!! I can...


View more questions Search