+ Reply to Thread
Results 1 to 2 of 2

Assistance with a script to auto sequence a column

  1. #1
    Forum Contributor
    Join Date
    08-14-2014
    Location
    US
    MS-Off Ver
    2013
    Posts
    135

    Assistance with a script to auto sequence a column

    Need some help with a script I tried to make and got some of it done right I think, but it doesn't work 100%
    Would like for when a new row is started from Column C:ZZ if no category id# is in A it triggers the script to add the line number. Would like the sequence to start in cell A2 and keep how when a row is removed it will re-sequence the numbers and if a row is added it will re-sequence for the new row numbers.



    Please Login or Register  to view this content.
    Thank you
    Attached Images Attached Images
    Last edited by Mr_Bill; 08-18-2014 at 10:56 PM.

  2. #2
    Forum Contributor Cerbera's Avatar
    Join Date
    07-06-2010
    Location
    Rotorua, New Zealand
    MS-Off Ver
    Excel 2007, 2013, 2016 & 365
    Posts
    137

    Re: Assistance with a script to auto sequence a column

    Just a thought, but couldn't you just use a formula in column A that checks if there is a value in columns C:ZZ of that row and if so display the cells row in the desired format:

    Please Login or Register  to view this content.
    (Put in A2 and copy down)

    That way if a row is removed it resequences. Obviously you'd have to decide how far down to fill down the formula, e.g 1000 rows, etc.

+ 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. auto- sequence number based on another column?
    By maynard in forum Excel General
    Replies: 6
    Last Post: 07-29-2016, 10:31 PM
  2. VBA Script Assistance for Table Comparison by Row
    By Iggy2k13 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-27-2013, 06:35 PM
  3. Replies: 0
    Last Post: 12-12-2012, 06:39 PM
  4. Need a special automatic sequence script
    By promoboy2 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-24-2012, 08:11 AM
  5. Excel 2007 : Database creation - VB script assistance
    By plato_pup in forum Excel General
    Replies: 10
    Last Post: 09-13-2011, 04:17 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