Sorting within boxes

Hi

If you change the structure of your pivot table to put those 2 items into positions 3 and 4, it should then automatically sort them in the way you want.

Once you have this data copied out, then it would be much easier to just reposition the columns in the output.

Is that an option?

rylo

That's not really an option, as this structure was selected as the optimum for the users of this report. Not my choice, but I work with what I'm given. But thanks for thinking outside the box.

Hi

If you can't change the structure of the pivot table, then could you build a second one as the basis for your sorted output? It wouldn't have to even be a permanent one - you could use a macro to build the second table to a temporary workbook / worksheet, then delete it afterwards.

rylo

I'm not quite sure how a second PT would help. Can you explain further (sorry, I'm slow; drawing me a picture helps). BTW, IF you include an example, I can't open zipped files. I can post 'em, but can't open 'em. Go figure.

I think I'm pretty dense. I just relooked at Rylo's first post, which is essentially what Romper is saying: create the pivot with Supv Name and Name in columns 3 and 4, copy the pivot to create the final report, then cut those two columns and place where my users like them. Why didn't I understand that before? I think that will work.

Or I could just use the great little macro that Romper that just posted. Thanks so much; it does exactly what I need it to do.

I am most satisfied! Thanks to both of you; you were giving me the right direction, I just wasn't seeing it. And a special thanks to Romper for creating the macro I needed; that saved me some time. I appreciate it.