Handling pivot tables with macros - Filtering fields
Hello!
How can I filter items from a certain field of a Pivot Table without having to use something like
where every item has to be turned off one by one? Is it possible to hide them all and then use visible.true to show only the item I want to see? Keep in mind that the items names aren't as simple as shown in the code, so using a changing string to call each name inside a loop isn't possible.
Please Login or Register to view this content.
Thanks in advance
Last edited by Pichingualas; 02-10-2012 at 12:33 PM.
Dang I guess no one knows
In case anyone else has this problem and needs a solution, I found a code which can be used, although for what I want I'm having to adapt it. The source I found it at is:
http://www.contextures.com/xlPivot03.html
I hope that helps someone.
Okay, this is the code I came up with.
It works perfectly.Please Login or Register to view this content.
Last edited by Pichingualas; 02-10-2012 at 12:34 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks