Code needed to resort multiple pivot tables

[tfoster]

Hi, I have a file with c. 50 pivot tables feeding off a selection of datasheets in the file (each pivot table is in its own sheet). All the pivot tables are currently sorted on one data field (same one for all pivot tables). I now need to re-sort all the pivot tables on another field (again it is the same named field for all pivot tables).
At present they are all ranked (largest to smallest) on a field called "Sum of MAT TY2" and I need to re-rank them all on a field called "Sum of Latest 26 Weeks2". Would a piece of code do this for me? Can anyone help?
Thanks, Tim

 

[Andrew Poulsom]

Have you tried recording a macro while doing it manually then putting the code in a suitable loop?