In my sheet, each parent row is a different employee. Each employee has child rows for each month of the year and a YTD row that contains KPI data for each moth. When entering in data, it is helpful for me to sort the parent rows by employee names and then switch to sorting by employee numbers, based on where I am sourcing the data. When I sort the parent rows, I find that the month child rows change order messing up the chronological order in our dashboard that is connected to the sheet and the formulas for the YTD rows.
How do I sort the parent rows without changing the order of the child rows?
