Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Sep 2001
    Posts
    238
    Thanks
    40
    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
    10,001
    Thanks
    423
    Thanked 1,608 Times in 1,452 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,442
    Thanks
    166
    Thanked 651 Times in 619 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
  •