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.
Bookmarks