fiberboysa
Board Regular
- Joined
- Apr 25, 2012
- Messages
- 106
- Office Version
- 365
- Platform
- Windows
Hi All,
After going through following threads and few more, I could not find a solution to my problem so starting a new thread.
https://www.mrexcel.com/forum/excel-questions/547911-filter-pivot-table-values-array-cells.html
https://www.mrexcel.com/forum/excel-questions/595213-pivot-table-master-report-filter.html
https://www.mrexcel.com/forum/excel-questions/588008-pivot-table-question.html
In these threads Mr. Jerry Sullivan helped people out I hope he or someone else will guide me as well.
I have a Workbook with several sheets and several Pivots on all sheets. And I want to filter them with one sheet i.e. if i change one cell value all pivots in all sheets get filter based on that cell value.
I hope few modification in code in above threads will do my job that may be putting worksheet even in all sheets and a loop that triggers on that cell value and filter all pivots on all sheets according to that cell value. Thanks!
After going through following threads and few more, I could not find a solution to my problem so starting a new thread.
https://www.mrexcel.com/forum/excel-questions/547911-filter-pivot-table-values-array-cells.html
https://www.mrexcel.com/forum/excel-questions/595213-pivot-table-master-report-filter.html
https://www.mrexcel.com/forum/excel-questions/588008-pivot-table-question.html
In these threads Mr. Jerry Sullivan helped people out I hope he or someone else will guide me as well.
I have a Workbook with several sheets and several Pivots on all sheets. And I want to filter them with one sheet i.e. if i change one cell value all pivots in all sheets get filter based on that cell value.
I hope few modification in code in above threads will do my job that may be putting worksheet even in all sheets and a loop that triggers on that cell value and filter all pivots on all sheets according to that cell value. Thanks!
