tleonardo1
New Member
- Joined
- Mar 31, 2002
- Messages
- 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.
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.