How to sort in Excel with headers link to all body parts

  • Thread starter Sorting in Excel for Item with label.
  • Start date
S

Sorting in Excel for Item with label.

I have a table that have subheaders and each subheader with rows of items
below them.
I wanted to sort all subitems from all subheaders according to value (in one
column); and have each subitem link to the subheader as label for that
particular item.

I guess what I need to do is link a cluster of items to it subheader; so
when I sort each item will include the subheader as label to show what
subheader it came from.
 
Top