ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Pivot table sorting (https://www.excelbanter.com/excel-programming/382579-pivot-table-sorting.html)

Graeme[_5_]

Pivot table sorting
 
I am trying to sort a pivot table in VBA. The help on the sort method is
rather unclear

Can anybody give me an example. I wish to sort a PT on 3 feilds within the
PT

Ta

Graeme



Martin Fishlock

Pivot table sorting
 
Hi Graeme:

Why not try doing it with the macro recorder and then look at the code. It
usually gets you started.

Otherwise take a look as Debra Dalgleish's site
http://www.contextures.com/tiptech.html
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"Graeme" wrote:

I am trying to sort a pivot table in VBA. The help on the sort method is
rather unclear

Can anybody give me an example. I wish to sort a PT on 3 feilds within the
PT

Ta

Graeme





All times are GMT +1. The time now is 03:55 PM.

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