Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Sep 2001
    Posts
    222
    Thanks
    37
    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,896
    Thanks
    420
    Thanked 1,585 Times in 1,434 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
    3,393
    Thanks
    164
    Thanked 634 Times in 602 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
  •