Hi all,

I am trying to create a filter on Sheet2 of a workbook that will filter the information that is in a Pivot table on Sheet 1. Sheet 2 is a table of values extracted from the pivot table, but for it to update, I have to go to Sheet1 each time and set the filter.

Is there a way to create the same filter that appears in the top left of my pivot table on sheet 2?

Thanks!!