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

    Jun 25, 2011, 05:09 AM
    Sequential numbering in excel 2007?
    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.
    BK201's Avatar
    BK201 Posts: 338, Reputation: 150
    Full Member
     
    #2

    Aug 1, 2011, 04:40 PM

    Im not sure if this is what you want but
    go to sheet 2, click on cell A1, type this
    =sheet1!A1+1
    drag and drop it to the other cells below.
    Or are u trying to solve a more complicated format?
    Naaldekokker's Avatar
    Naaldekokker Posts: 2, Reputation: 1
    New Member
     
    #3

    Aug 2, 2011, 03:06 AM
    Comment on BK201's post
    Trying to solve a more complicated format. Thank you
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
     
    #4

    Aug 2, 2011, 03:19 AM

    First when posting a follow-up question or info, please use the Answer options at the bottom of the page rather than the Comments.

    Sequential numbering is easy in Excel, you simply enter a formula that increments another value by 1. To help further you need to be more detailed about your needs.

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

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.

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.

Macros for sequential numbering in multiple worksheets in excel with [ 1 Answers ]

I have a workbook with worksheets for each day of the month. I need to subtract one day to = equal number of days left in the month. Ex(May 1st there are 31 days left in month, May 2nd, worksheet two, there are 30 days left in the month, and so on and so forth.) Is there a way to have these days...

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