Please see attached file as you read along.
SCENARIO:
-3 pivot tables based off of the same data source.
- Each pivot table has 2 columns: (A)School name & (B)Mean SAT section score
Need to program buttons, which should do 2 things:
1) Filter top 10 items by value in one pivot table &
2) show only those filtered items on all other pivot tables in the sheet.
So for example, all pivot tables should then reflect top 10 schools by Mean Math section scores (even the pivots with Reading section & Writing section scores)
In total, looking to have 6 buttons: three buttons for top 10 & three for bottom 10
Beginner at VBA. How do I go about this?
Note: This scenario is a replica of my problem with sample data as I can't share original.
Thanks!
Bookmarks