Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Sequential numbering in excel 2007? (https://www.askmehelpdesk.com/showthread.php?t=583967)

  • Jun 25, 2011, 05:09 AM
    Naaldekokker
    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.
  • Aug 1, 2011, 04:40 PM
    BK201

    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?
  • Aug 2, 2011, 03:06 AM
    Naaldekokker
    Comment on BK201's post
    Trying to solve a more complicated format. Thank you
  • Aug 2, 2011, 03:19 AM
    ScottGem

    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.

  • All times are GMT -7. The time now is 03:01 PM.