hi all,
is there any way to manipulate PT groupings other than Selection.Group?
For example, if I have a PT that already has manual groupings, can I add/remove items (without ungrouping everything) with VBA?
I've been spinning my wheels on this problem for weeks...
in the example above, lettuce is in the wrong category. Is there a way to ungroup it from Fruit and add it to Veggie?
is there any way to manipulate PT groupings other than Selection.Group?
For example, if I have a PT that already has manual groupings, can I add/remove items (without ungrouping everything) with VBA?
I've been spinning my wheels on this problem for weeks...
Code:
Item2 Item
Fruit apple
orange
pear
lettuce
Veggie raddish
bean
in the example above, lettuce is in the wrong category. Is there a way to ungroup it from Fruit and add it to Veggie?