Attaching rows to one row when sorting

G

Gary Fitzgerald

How can one Tie child rows to one parent row so that when A-Z sorting is
applied to a column the table is sorted but the child rows stay tied to there
parent row?

Note: The cells on the child rows are blank in the column used for sorting.

Thanks a Mil for any direction
 
J

Joel

There are two ways. One is to write custom macro. The second is to add a
column with an index numbers to each row. Parents and child should be
assigned the same index number. the use the index number as a sort key.
 
R

rdwj

or possibly adding the parents entry in the sort column to the child entry,
sort column, and formatting it in the same color as the background....
 
Top