An example:
The below represents a list of data that I need sorted. There are actually 26 columns of data, but I didn't bother to list them and won't unless it's needed.
What I'm trying to do is to sort the data within the section it is in. So, between "Corporate" and "Central" I need that data sorted. And between "Central" and "South" I need that sorted. And so on.
The total number of rows can be anywhere between 50 and 400. There is never the same amount.
The sort order is Ascending and is by Column C, then Column D.
Any suggestions?
Thanks!
Code: Select all
Corporate
5686
5729
5669
5322
2706
2406
Central
5699
5032
4419
4945
3570
South
4974
4950
5380
5540
4591
1807
4329
5619
West
3641
3948
4720
4038
4971
5328
East
5314
5537
5067
4040
5074
5642
2758
2725
2724