Hi Guys,
I have a workbook with multiple sheets. On those sheets, there are multiple pivottables.
I need a macro that search for all the pivottables (we don't know each pivottable's name) on all sheets and filter them by a cell valule, for example in Sheet(1) A1.
The purpose of this is to be sure that all pivottables are filtered by the same value. Then I can retrieve data from those.
Thanks!
Bookmarks