Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
Daily Dose of Excel » Filter Pivot Table Source Data II

Filter Pivot Table Source Data II

In this post I show the main procedure that filters a pivot table’s source range. In this post, I show how to determine which filters are applied to a particular cell in a pivot table. First, I count the number of filters. Public Function FilterCount(Target As Range) As Long         Dim [...] Read More...

Read the complete post at http://www.dailydoseofexcel.com/archives/2010/11/09/filter-pivot-table-source-data-ii/

Posted Nov 09 2010, 02:47 PM by Daily Dose of Excel
Filed under: ,
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.