Results 1 to 5 of 5

Autonumber Until Certain Value then Restart

Threaded View

  1. #1
    Registered User
    Join Date
    03-25-2013
    Location
    Phoenix, AZ
    MS-Off Ver
    Excel 2007
    Posts
    13

    Autonumber Until Certain Value then Restart

    I hope I can articulate clearly what I'm trying to do.

    So I have a list of data that I do not know the length of in advance. I need to automatically number each entry (the entries themselves make no difference) to a certain number and then start back at one. So say I have a list of 9 entries and I want them to label 1, 2, 3, 4 and then on the 5th entry is starts back at one, then at the 9th entry it's 1 again and so on for longer lists. My mind just isn't wrapping around the code for this. I've attached a sample workbook with what I've thought of so far but I just don't even know where to begin to get it to start over. I've tried nested for-loops but I get errors....
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Userform restart after end sub
    By Sibrulotte in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-13-2011, 02:34 PM
  2. Re: 'Do Until...' Restart
    By Jack in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-22-2006, 04:10 AM
  3. [SOLVED] Re: 'Do Until...' Restart
    By Jack in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-21-2006, 12:32 PM
  4. 'Do Until...' Restart
    By Jack in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-21-2006, 11:10 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