Hi ,
So i have 4 pivot tables - Pivot1,Pivot2,Pivot3,Pivot4 in one sheet. All the pivot tables have one filter that is common i.e. "combination" . Now i want to loop through all the filter values one by one in the combination in all the pivot tables. Can somebody help me please. I'm stuck at this for a long time. Completely new to VBA.
So i have 4 pivot tables - Pivot1,Pivot2,Pivot3,Pivot4 in one sheet. All the pivot tables have one filter that is common i.e. "combination" . Now i want to loop through all the filter values one by one in the combination in all the pivot tables. Can somebody help me please. I'm stuck at this for a long time. Completely new to VBA.