+ Reply to Thread
Results 1 to 1 of 1

Using Multilevel Lists in VBA

  1. #1
    Registered User
    Join Date
    01-12-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    20

    Using Multilevel Lists in VBA

    I am trying to write a procedure that will take a multilevel list and make it into a table. I can create a table with the correct dimensions, but what I am struggling with is then filling out the table. Here is my numbering scheme:

    1. Level 1 Item 1
    1.1. Level 2 Item 1
    1.2. Level 2 Item 2
    1.3. Level 2 Item 3
    2. Level 1 Item 2
    2.1. Level 2 Item 1

    and my goal is a table that looks like:

    Coulumn1 | Column 2
    1. Level 1 Item 1 | 1.1. Level 2 Item 1
    1. Level 1 Item 1 | 1.2. Level 2 Item 2
    1. Level 1 Item 1 | 1.3. Level 2 Item 3
    2. Level 1 Item 2 | 2.1. Level 2 Item 1

    Essentially I am trying to turn a one dimensional array into a two dimensional array, but I can't figure out how to get the Level 1 items to line up with the correct level 2 items. I have been searching through the activedocument.Lists collection searching for something that would give me a way to matche up the level 1 items with the level 2 items. Any help would be appreciated.
    Last edited by drstrings; 08-07-2013 at 08:47 PM. Reason: formatting

+ 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. multilevel line graph with different value
    By bertique in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-14-2013, 03:36 AM
  2. MultiLevel BOM Comparison
    By gopinathtt in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 12-27-2012, 07:33 PM
  3. rotating horizontal axis text in multilevel
    By mahmoodn in forum Excel General
    Replies: 2
    Last Post: 07-18-2011, 12:02 PM
  4. [SOLVED] Multilevel Ranges
    By Cheer-Phil-ly in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-30-2005, 05:20 PM
  5. Multilevel Sorting?
    By Mike in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-18-2005, 11:06 PM

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