You would like to create an Excel file with Multiple Sheets, each for Region Value. If there are three distinct Regions values in Region Column, it should create an Excel file with three excel sheets. So if tomorrow, the Region decreases or increases, the sheets should be created according to distinct values. Mar 29, 2019 · This article was co-authored by our trained team of editors and researchers who validated it for accuracy and comprehensiveness. wikiHow's Content Management Team carefully monitors the work from our editorial staff to ensure that each article meets our high quality standards.

May 24, 2012 · I have read on various sources that it is possible to use the same slicer for pivot tables on different worksheets. I'm able to get this to work if the PTs are on the same page, but not multiple pages. The pivot tables pull their data from the same table on another page in the workbook. I want to filter both pivots with the same two slicers.