Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Macro Needed to Parse Data

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    48
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Old system spits out data that has info such as
    Heading1
    Subheading1
    SubSubheading1

    Under a heading there can be multiple subheadings and below that multiple subsubheadings. I want a macro that will grab the data and return 3 columns of data from the one. The first column should be filled with heading the second with subheading, the third with subsubheading. The trick is I want all of the first colum cells to be filled with the heading value until it finds another heading value etc. So the final list will look like this:

    heading1 subheading1 subheading1
    heading1 subheading1 subheading2
    heading1 subheading1 subheading3
    heading1 subheading2 subheading1
    heading1 subheading2 subheading2
    heading2 subheading1 subheading1
    heading2 subheading2 subheading1

    etc.

  2. #2
    MrExcel MVP Al Chara's Avatar
    Join Date
    Feb 2002
    Location
    Newark, Delaware
    Posts
    1,701
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Your list doesn't have any subsubheadings. Is that a mistake or is it supposed to be that way. Explain more about the order that these headings and such are in. Your final list doesn't seem to follow any order.

  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    48
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Sorry the third column should all be subsubheadings.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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