MarkCBB
Active Member
- Joined
- Apr 12, 2010
- Messages
- 497
HI there,
I currently have a few pivot tables that get updated weekly with more information.
However every time I update the pivot tables, I end up re sorting all of them by moving the rows with the Drag function.
I also have a list of the row items in another Range (I manually type, i.e. from sheet11.range(A2) and downwards). the order that the items are sorted in this this is the order I sort the Pivot row Items in each of the pivot tables.
I am looking for some Code to sort 1 Pivot table according to the list.
I should be able to adapt this to all the other relevant Pivot Tables.
thank you.
I currently have a few pivot tables that get updated weekly with more information.
However every time I update the pivot tables, I end up re sorting all of them by moving the rows with the Drag function.
I also have a list of the row items in another Range (I manually type, i.e. from sheet11.range(A2) and downwards). the order that the items are sorted in this this is the order I sort the Pivot row Items in each of the pivot tables.
I am looking for some Code to sort 1 Pivot table according to the list.
I should be able to adapt this to all the other relevant Pivot Tables.
thank you.