+ Reply to Thread
Results 1 to 11 of 11

Auto numbering rows with names

  1. #1
    Forum Contributor
    Join Date
    05-06-2009
    Location
    Singapore
    MS-Off Ver
    Excel 2003
    Posts
    340

    Auto numbering rows with names

    Hi, this worksheet has a macro that deletes blank cells and moves the names upwards when the names that are not present are dragged into the absent column. There's also a code in there to number the rows with names. How do I get it to continue from the last number in Column A to Column C?
    Last edited by bqheng; 02-03-2015 at 07:51 PM.

  2. #2
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,551

    Re: Auto numbering rows with names

    Quote Originally Posted by bqheng View Post
    Hi, this worksheet has a macro that deletes blank cells and moves the names upwards when the names that are not present are dragged into the absent column. There's also a code in there to number the rows with names. How do I get it to continue from the last number in Column A to Column C?
    There's no macro in your sample file.

  3. #3
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Mullsjoe, Sweden
    MS-Off Ver
    Excel 2019 and not sure I like it
    Posts
    4,710

    Re: Auto numbering rows with names

    There's no macro in your sample file.
    Right click on tab for Sheet1, click on "View Code", then right click on "ThisWorkbook" and click on "View Code"

  4. #4
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,551

    Re: Auto numbering rows with names

    Quote Originally Posted by Alf View Post
    Right click on tab for Sheet1, click on "View Code", then right click on "ThisWorkbook" and click on "View Code"
    Okay, what am I missing here? I saw this before and it doesn't look like it does what he said, nor is there any data in the worksheet so I'm not sure how to proceed.



    Please Login or Register  to view this content.

  5. #5
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Mullsjoe, Sweden
    MS-Off Ver
    Excel 2019 and not sure I like it
    Posts
    4,710

    Re: Auto numbering rows with names

    Okay, what am I missing here?
    I assume this is the code the OP is referring to but how to help him I have not the foggiest! Hopefully you may be able to do so.

    Alf

  6. #6
    Forum Contributor
    Join Date
    05-06-2009
    Location
    Singapore
    MS-Off Ver
    Excel 2003
    Posts
    340

    Re: Auto numbering rows with names

    Hi, sorry uploaded the wrong file. This is the correct one with the description in first post
    Attached Files Attached Files

  7. #7
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,551

    Re: Auto numbering rows with names

    I think you were referring to the code in the selection change and this will probably work for you. Just be advised that this code will run every time you select a different cell in your spreadsheet. You may want to consider running it from a button or the before double click event, then you could just double click on the sheet and it would run for you. Good luck!

    Please Login or Register  to view this content.
    Last edited by skywriter; 02-03-2015 at 09:53 PM.

  8. #8
    Forum Contributor
    Join Date
    05-06-2009
    Location
    Singapore
    MS-Off Ver
    Excel 2003
    Posts
    340

    Re: Auto numbering rows with names

    Hi, it works for column A. Is it possible to get the first number in column C to start from the last number of Column A?

  9. #9
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,551

    Re: Auto numbering rows with names

    Quote Originally Posted by bqheng View Post
    Hi, it works for column A. Is it possible to get the first number in column C to start from the last number of Column A?

    Please Login or Register  to view this content.

  10. #10
    Forum Contributor
    Join Date
    05-06-2009
    Location
    Singapore
    MS-Off Ver
    Excel 2003
    Posts
    340

    Re: Auto numbering rows with names

    it works nicely now, thank you so much

  11. #11
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,551

    Re: Auto numbering rows with names

    My pleasure.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Row to multiple rows and auto numbering............
    By SHIGO in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-27-2012, 10:40 AM
  2. Replies: 1
    Last Post: 11-08-2009, 04:10 PM
  3. Auto Numbering Skipping Rows
    By jkobz in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-01-2009, 11:50 PM
  4. Auto numbering for different names
    By leeaw in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-27-2009, 05:22 AM
  5. Auto numbering for different names
    By leeaw in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-24-2009, 03:08 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1