Macro Needed to Parse Data

tleonardo1 · Apr 1st, 2002, 02:09 PM

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.

Al Chara · Apr 1st, 2002, 02:40 PM

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.

tleonardo1 · Apr 1st, 2002, 03:29 PM

Sorry the third column should all be subsubheadings.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 1st, 2002, 02:09 PM	#1
tleonardo1 New Member Join Date: Mar 2002 Posts: 48	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.

Apr 1st, 2002, 02:40 PM	#2
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	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.

Apr 1st, 2002, 03:29 PM	#3
tleonardo1 New Member Join Date: Mar 2002 Posts: 48	Sorry the third column should all be subsubheadings.