How?
For a site map/navigation excel sheet I'd like to indent the cells relating to their nesting on the site. e.g.
At the moment:
What I want:
Now I found a macro to insert whole rows when values in a column change, but don't have the macro skill to adapt it. Is this possible?
Basically, if value is "2", insert two cells and nudge row right. I thought text>columns would do it but it overwrites the adjacent data.
Any help much appreciated.
For a site map/navigation excel sheet I'd like to indent the cells relating to their nesting on the site. e.g.
At the moment:
Code:
| 1 | Home |
| 2 | Section 1 |
| 3 | Section 1a |
| 3 | Section 1b |
| 3 | Section 1c |
| 3 | Section 1d |
| 2 | Section 2 |
| 3 | Section 2a |
| 3 | Section 2b |What I want:
Code:
| 1 | Home |
| | 2 | Section 1 |
| | | 3 | Section 1a |
| | | 3 | Section 1b |
| | | 3 | Section 1c |
| | | 3 | Section 1d |
| | 2 | Section 2 |
| | | 3 | Section 2a |
| | | 3 | Section 2b |Now I found a macro to insert whole rows when values in a column change, but don't have the macro skill to adapt it. Is this possible?
Basically, if value is "2", insert two cells and nudge row right. I thought text>columns would do it but it overwrites the adjacent data.
Any help much appreciated.