Attaching rows to one row when sorting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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....
 
Back
Top