Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Sep 2001
    Posts
    213
    Thanks
    32
    Thanked 0 Times in 0 Posts

    Auto numbering rows

    Is there a formula/macro to have rows automatically renumber after rows are added and/or deleted from a spreadsheet? I generate route sheets with rows of names and addresses for my boss's lawn treatment business. There are four treatments a year for each town and the names and addresses change accordingly. Currently I am dragging the numbers down the column to automatically renumber after adding and deleting rows of names and addresses. (25 names and addresses per sheet) Some towns are only one sheet, so it's not a big deal. But a few towns generate 11 or 12 sheets so it would be nice to not have to go back and renumber everything from the beginning by re-dragging the numbers down the column.

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,480
    Thanks
    376
    Thanked 1,471 Times in 1,339 Posts
    K,

    This should do what you want:

    =ROW()-2

    The above assumes that the first instance of the formula is in ROW 3, change as appropriate.

    Now when you insert rows all the numbers will change accordingly you just need to copy the formula into the new rows.
    numberrows.PNG

    HTH
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. The Following User Says Thank You to RetiredGeek For This Useful Post:

    k32rem (2016-07-26)

  4. #3
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,930
    Thanks
    139
    Thanked 502 Times in 478 Posts
    Hi RG

    ..an effective solution from the Master.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •