Hello everyone,
I have 2 pivot tables,
I would like to know how to create a VBA code so that the first pivot table (called PivotTable1) will group by numbers in increments of 10
Whereas the second pivot table (called Pivot Table2) will group by numbers in increments of 100,
I tried to record but every time I refresh the data it doesn't work..
Thank you for your help
I have 2 pivot tables,
I would like to know how to create a VBA code so that the first pivot table (called PivotTable1) will group by numbers in increments of 10
Whereas the second pivot table (called Pivot Table2) will group by numbers in increments of 100,
I tried to record but every time I refresh the data it doesn't work..
Thank you for your help