Hello Everyone,
I have wrote VBA code for a pivot table that includes a filter for 10 shops I am dealing with. Is there a way to put each shops data into a new tab within the same workbook from the Pivot. So there will now be 10 new tabs with all of the respective shops data.
Any help is much appreciated.
Thanks!
I have wrote VBA code for a pivot table that includes a filter for 10 shops I am dealing with. Is there a way to put each shops data into a new tab within the same workbook from the Pivot. So there will now be 10 new tabs with all of the respective shops data.
Any help is much appreciated.
Thanks!