Filter Pivot based on data in range

urobee

Board Regular
Joined
Jan 30, 2015
Messages
98
Hy,
I have 5 pivot table on a sheet (PIVOT).
I need to filter the data based a list of criterias on another sheet (WORK2)
The list contains the criterias i need to unselect in all the pivot tables (.PivotItems.Visible = False)

Can You help me in this case?
Thank You Guys! :)
 

Some videos you may like

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

Watch MrExcel Video

Forum statistics

Threads
1,108,768
Messages
5,524,784
Members
409,600
Latest member
Dunnowhatfor

This Week's Hot Topics

Top