Creating an Excel hierarchy
Lupon
-
Raymond PENTIER Posted messages 58216 Registration date Status Contributor Last intervention -
Raymond PENTIER Posted messages 58216 Registration date Status Contributor 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!
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 answers
-
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)
-
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)
