VBA Filter

[vjmsilva]

I have a range of cells (tab 1) that has to be a filter in the principal tab.

I have a pivot table based on the principal tab. The range of cells in tab 1 has not to considered on the pivot table.

How I can create this type a filter?

Regards,

 

[pbornemeier]

Welcome to the Board!

What column in the source data for the pivot table contains the values that are on Tab 1?
Do the values in Tab 1 start in cell A1 and continue down?
Do you want the PivotTable to show all rows that do not have values listed on Tab 1?
What worksheet is the PivotTable on? Does the main part of the Pivot Table start in cell A3?