Results 1 to 3 of 3

WBS numbering help, auto numbering with indenture

Threaded View

  1. #1
    Registered User
    Join Date
    02-08-2007
    Posts
    2

    WBS numbering help, auto numbering with indenture

    hi everyone.

    here's what i want my end result to look like (think hundreds, thousands of line longer):

    Column A:
    1.4
    1.4.1
    1.4.1.1
    1.4.1.2
    1.4.1.3
    1.4.2
    1.4.2.1
    1.4.2.2
    1.4.2.3
    1.4.2.3.1
    1.4.2.4

    Column B:
    GROUND SYSTEM
    Data Comm System Integrator
    Program Management
    System Engineering
    Integration and Test
    En Route Contractor
    Program Management
    System Engineering
    Integration and Test
    En Route Display System
    Implementation


    ETC

    what i have is thousands of lines (indented to represent parent-child relationships for Column B....what i want is to automate Column A so that I don't have to phyiscally type in AND indent thousands of numbers.

    I want to be able to type something into column B and for Column A to automatcially number it BASED on the indentation in column B AND it's order in the spreadsheet.

    Also, note that the level (e.g. 1.1.1.1.1.1.1 a.ka. number of decimals ranges from 1 to 15)

    can anyone help me please??

    i would greatly appreciate it.

    Thanks!!!
    Last edited by VBA Noob; 02-08-2007 at 06:57 PM.

Thread Information

Users Browsing this Thread

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

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