Hi
wondering if someone could assist with the below
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?
Many Thanks
Bookmarks