Opposite Pivot Table Filter in 2nd Pivot Table

[jamesrr25]

Hello,

I am attempting to create a "peer" pivot table = PVT2(H5), based off the filter selection in PVT1(cell E5). My plan is to use a combo box to have the user select a school to review in PVT1, and by doing so they could view that school's peers(all other schools except the one selected) in PVT2. The Rows, Columns, and Values should remain the same for both pivot tables, the only thing changing would be the Filter selection.

Notes:
- using Excel 2010, but moving to proplus soon.
- For the schools list I will always have a finite list(approx 100), so this is not something that will adjust.

Im assuming there is some fancy macro that I could write to get this done, but my vba skills can barely be called skills at this point. Please help! Thank you


Excel 2013

Row\Col	A​	B​	C​	D​	E​	F​	G​	H​	I​	J​
3​	School	Grade	subject
4​	School1	1st	Math
5​	School2	2nd	reading		PVT1			PVT2
6​	School3	3rd	writing		School	School1		School	(Multiple Items)
7​	School4	4th	science
8​	School5	5th	physics		Row Labels	Count of Grade		Row Labels	Count of Grade
9​	School6	6th	history		Math	2​		history	1​
10​	School1	3rd	Math		Grand Total	2​		Math	1​
11​	School2	4th	reading					physics	1​
12​	School3	5th	Math					reading	3​
13​	School4	6th	reading					science	2​
14​	School5	5th	writing					writing	2​
15​	School6	6th	science					Grand Total	10​
16​
17​
18​

<tbody>
</tbody>

​