ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to sort pivot table? (https://www.excelbanter.com/excel-programming/281336-how-sort-pivot-table.html)

RADO[_3_]

How to sort pivot table?
 
I will appreciate advice on how to sort a desired pivot table column field
in VBA.

I tried Sort method, but VBA help is very unclear on how to use it with
pivot tables. What should be "key1" in this case?

Thanks in advance -

RADO



Tom Ogilvy

How to sort pivot table?
 
You have to sort the table based on the value in a row field.

--
Regards,
Tom Ogilvy


"RADO" wrote in message
...
I will appreciate advice on how to sort a desired pivot table column field
in VBA.

I tried Sort method, but VBA help is very unclear on how to use it with
pivot tables. What should be "key1" in this case?

Thanks in advance -

RADO






All times are GMT +1. The time now is 01:18 PM.

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