Hi Guys, I'm needing some help here.
The case: I have several pivots on the same sheet, and I want to filter allone according to a Cell value in D1.
The first pivottable is located on A3
I tried the following:
But I'm getting and error saying: "Object Required"Please Login or Register to view this content.
First, I need to solve how to get the PivotTables names to use in the macro.
After that, I need to apply this macro to all the tables on the current sheet.
I'm on Excel 2007.
Any Ideas?
Cheers.
Leandro (from Argentina)
Bookmarks