Using VBA to apply values in a range to the filter in a Pivot Table

**PFDave** · 03-06-2017, 05:01 AM

Hi,

I have a list which I need to filter for within a pivot table. The issue is that there are 101 values and it takes an age to manually select each for the filter not to mention the worry of incorrect selections.

So I've tried to amend some code found online but I've never had any joy with Autopopulation of Pivot Table filters so I could do with some help please.

Thanks in advance

Please Login or Register  to view this content.

**PFDave** · 03-06-2017, 09:17 AM

Sorry guys quick bump as I'm still struggling on this one. Thanks in advance

Using VBA to apply values in a range to the filter in a Pivot Table

LinkBack

Thread Tools

Rate This Thread

Display

Using VBA to apply values in a range to the filter in a Pivot Table

Re: Using VBA to apply values in a range to the filter in a Pivot Table

Thread Information

Users Browsing this Thread

Similar Threads

How to filter Top 10 values on 1 pivot table & reflect filtered items on all pivot tables

[SOLVED] Help with code to Apply Filter to Pivot Table based on a cell value

Apply Blank Pivot Table filter that will automatically include new data

Filter pivot table on range of cell values

Pivot Table filter by a date range inlcuding items with no data inisde that range only

Excel 2007 : Pivot table top 5 filter,pivot table size and range

Apply filter in a pivot table

Bookmarks

Bookmarks

Posting Permissions