View original (French)

Creating an Excel hierarchy

Lupon -  
Raymond PENTIER Posted messages 58548 Registration date   Status Contributeur Last intervention   -
Hello,

I want to create a tree structure code like in this file >> https://www.cjoint.com/c/ICAqxztfaoK

But I have no idea how to set up the cells.... The idea is that when I insert or move a row, the code updates like a table of contents.

Thank you for your help!

2 réponses

Réponse 1 / 2
yclik Posted messages 68 Registration date   Status Membre Last intervention   1 604
 
Good evening
a formula
in c7 
=B$6&"."&ROW()-ROW(B$6)

to copy down and adapt for each new code
in c13 
=B$12&"."&ROW()-ROW(B$12)
0
Réponse 2 / 2
Raymond PENTIER Posted messages 58548 Registration date   Status Contributeur Last intervention   17 474
 
Good evening.

It seems to me that it would be infinitely simpler and more effective to do this work in Word, with hierarchical lists (multi-level lists), automatic numbering, styles, and possibly the Outline mode.

--
Retirement is great! Especially in the Caribbean...
Raymond (INSA, AFPA)
0