Hello,
I have an excel file consisting of :
- I have an excel file consisting of: a data tab and x analysis tabs with pivot tables based on the same range of data present in the 1st data tab.
I would like to have a vba macro that would allow me to identify the fields used in all the pivot tables in the workbook.
The data used in :
- filter
- columns
- rows
The idea is to easily identify the fields (in the data tab) that are used the most and those that are not used or not very much.
Thanking you in advance
I have an excel file consisting of :
- I have an excel file consisting of: a data tab and x analysis tabs with pivot tables based on the same range of data present in the 1st data tab.
I would like to have a vba macro that would allow me to identify the fields used in all the pivot tables in the workbook.
The data used in :
- filter
- columns
- rows
The idea is to easily identify the fields (in the data tab) that are used the most and those that are not used or not very much.
Thanking you in advance