Pivot table to refresh and source data to change using visible rows on a filtered sheet

Hi


i have 5 pivot tables on 5sheets, all looking at the same source data in sheet 6

on the source data there is a filter on the headers, if you change the filter, is it possible for all 5 pivot tables to update according to the filter?


my starting point is the below, but there probably is a better way
but i would want the sourcedata to equal visible rows on the source data sheet
headers run A:K and up to row 10000

Please Login or Register  to view this content.

Many Thanks