HalaYassin
New Member
- Joined
- Mar 3, 2017
- Messages
- 1
Hi
I am trying to find a way to automatically outline a hierarchy in Excel (group rows)
I cannot find a code to do that either
For example:
[TABLE="width: 573"]
<tbody>[TR]
[TD]Code[/TD]
[TD]Item[/TD]
[TD]Rollup[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]A[/TD]
[TD]Title[/TD]
[/TR]
[TR]
[TD]1.1[/TD]
[TD]B[/TD]
[TD]Subtitle Level 1[/TD]
[/TR]
[TR]
[TD]1.1.1[/TD]
[TD]C[/TD]
[TD]Compare[/TD]
[/TR]
[TR]
[TD]1.2[/TD]
[TD]D[/TD]
[TD]Subtitle Level 1[/TD]
[/TR]
[TR]
[TD]1.2.1[/TD]
[TD]E[/TD]
[TD]Subtitle Level 2[/TD]
[/TR]
[TR]
[TD]1.2.1.1[/TD]
[TD]F[/TD]
[TD]Compare[/TD]
[/TR]
[TR]
[TD]1.2.1.2[/TD]
[TD]G[/TD]
[TD]Compare[/TD]
[/TR]
[TR]
[TD]1.2.1.3[/TD]
[TD]H[/TD]
[TD]Compare[/TD]
[/TR]
</tbody><colgroup><col span="3"></colgroup>[/TABLE]
I would like to be able to open code 1, then to see 1.1 and 1.2. From there I would like to open that to see the levels below
Not sure if I am expressing myself correctly
Thank you so much for your help
I am trying to find a way to automatically outline a hierarchy in Excel (group rows)
I cannot find a code to do that either
For example:
[TABLE="width: 573"]
<tbody>[TR]
[TD]Code[/TD]
[TD]Item[/TD]
[TD]Rollup[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]A[/TD]
[TD]Title[/TD]
[/TR]
[TR]
[TD]1.1[/TD]
[TD]B[/TD]
[TD]Subtitle Level 1[/TD]
[/TR]
[TR]
[TD]1.1.1[/TD]
[TD]C[/TD]
[TD]Compare[/TD]
[/TR]
[TR]
[TD]1.2[/TD]
[TD]D[/TD]
[TD]Subtitle Level 1[/TD]
[/TR]
[TR]
[TD]1.2.1[/TD]
[TD]E[/TD]
[TD]Subtitle Level 2[/TD]
[/TR]
[TR]
[TD]1.2.1.1[/TD]
[TD]F[/TD]
[TD]Compare[/TD]
[/TR]
[TR]
[TD]1.2.1.2[/TD]
[TD]G[/TD]
[TD]Compare[/TD]
[/TR]
[TR]
[TD]1.2.1.3[/TD]
[TD]H[/TD]
[TD]Compare[/TD]
[/TR]
</tbody><colgroup><col span="3"></colgroup>[/TABLE]
I would like to be able to open code 1, then to see 1.1 and 1.2. From there I would like to open that to see the levels below
Not sure if I am expressing myself correctly
Thank you so much for your help