[b]Excel Total/Subtotal Sort Problem[/b] 1

[Texanite]

I have a 10,000 row payroll spreadsheet that I need to work with the totals and subtotals without the detail. Part of the problem is that when I collapse the subtotals they show up in the amount column (K) but I need the information that is in column I in order to do my sorting. How do I get the information in column I on the row that has the subtotal? Actually it could be in unused column (U) and that would work just as well. I just need to be able to see the information.

Thanks,
Texanite

 

[SkipVought]

Texanite,

Try using the PivotTabel Wizard to report the subtotals you need. You'll get EVERYHING that you need, I believe!



Skip,

Want to get great answers to your Tek-Tips questions? Have a look at faq222-2244