Dear community
I have attached an example of pivot and VBA code which loops w/o problem through a pivot table and copies data, in this case for the pivotfield "Basin" into another table.
I just would like the same but not on "Basin", but "ProductGroup".
By changing the relevant codes, it does not work.
I am beginner of VBA, so my apologies.
Furthermore I would be glad to have a solution that after the looping is completed, it returns back to "(All)" in the case of existing/attached file and same (to "ProductGroup") if it loops through "ProductGroup" in the changed file.
Thank you for any support.
Best regards
Heinz