ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Sorty PivotTable by ColumnField totals (https://www.excelbanter.com/excel-programming/323124-sorty-pivottable-columnfield-totals.html)

Paul Martin

Sorty PivotTable by ColumnField totals
 
Hi all

Using VBA, I want to sort a pivot table by column fields totals
(descending). When I use PivotFields.AutoSort, it sorts by the field
names, not the totals. Any suggestions please?

Thanks in advance

Paul Martin
Melbourne, Australia


All times are GMT +1. The time now is 11:00 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com