Sorting within boxes yet again

[jomili]

This is the third post I've had on this subject, going back years without a true resolution. The last post is here: http://www.excelforum.com/showthread...27#post2553327
The process is I'm creating a pivot from a lot of data. Then the pivot turns into a report. The trick to it is for each deptID, we want the supervisors in order by name. The finished report has to be in the format shown (but with the columns expanded, of course). The overall issue is shown in the pictures. Note that Koli (the names are fake) is no longer bordered by the two total lines:Attachment 409485

A related issue may be that the macro I'm still trying to use (below) doesn't take the Progam Code (PAC) into account. The range to sort is all fields within each DeptID, sorted in Supervisor order,and PAC needs to stay with the employess (a DeptID might have more than one PAC, and a Supervisor MIGHT be a supervisor of more than one PAC). Any help would be greatly appreciated.

Please Login or Register  to view this content.

[Pauleyb]

Maybe it is me, but this is the second post I have tried to open an 'Attachment' and I get an invalid link error. Grrr.
In looking at your image, it seems to have a problem when there is only one item in a 'group'. Try changing this line of code:

Please Login or Register  to view this content.

[jomili]

For someone who can't see the attachment you see pretty well. The update seemed to fix the issue with the single lines. I'll be checking it against different runs today, so probably won't post again until late today or tomorrow, but in anticipation of a successful solution, THANK YOU!

[Pauleyb]

Glad it worked. You can pay me back with a lunch at Franklins...

[jomili]

I didn't spot any issues, but have settled on an alternative method for creating my table, using Subtotals instead of a Pivot, so I won't be using the Resort macro in the foreseeable future. But thanks to all the people who have helped me with it over the years, and most lately Pauleyb, I'll keep this one in my toolbox; no telling when it will come in handy. Thanks so much!

Pauleyb, I'd love to take you to Franklins, except as a vegan I don't find much use for barbecue places, unless it's one that makes a good vegan pulled pork (see http://www.onegreenplanet.org/vegan-...bbq-jackfruit/)