Filter Fileds

[Mifer8]

Hi All.

I'm trying to set up some filters on a range. I know how to do it on a PivotTable but I'm trying to replicate the below code on a simple Data range. Can you please help me on this?

FiterArr = Array("Others")
For Each Criteria In PV_2.PivotFields("Employee ID").PivotItems
If Not IsError(Application.Match(PTItm.Caption, FiterArr, 0)) Then ' check if current item is not in the filter array
PTItm.Visible = False
Else
PTItm.Visible = True
End If
Next PTItm

 

[DanteAmor]

Hi and welcome to MrExcel!

Check this:

VBA to Filter Column Labels using Filter List

Hi Everyone I need to filter my pivot table column label for Column "D1". I need this because everytime there is new item in D1, pivot table automatically clears all filters and starts showing all items. Just to keep a record that which items I need to be seen, I created a list "PFilters" with...

www.mrexcel.com