Trying to link Cell F5 (Worksheet 1) to the pivot table filter (Op Unit) in Worksheet 2 to change the pivot table when a new value is entered in Cell F5. Thanks for your help
<tbody>
</tbody>
Worksheet 1: (Summary) | Worksheet 2: (Pivot PSC Vol) | |||||||
OP Unit: | 189 | Op Unit | (All) | |||||
Cell: F5 | ||||||||
Values | | PivotTable Name: PivotTable1 | ||||||
Wk 28 | 976284 | |||||||
Wk 29 | 1014784 | |||||||
Wk 30 | 1002135 | |||||||
Wk 31 | 1003555 | |||||||
Wk 32 | 1016709 | |||||||
Wk 33 | 1024173 | |||||||
Wk 34 | 1021025 | |||||||
Wk 35 | 1018841 | |||||||
Wk 36 | 945889 | |||||||
Wk 37 | 951032 | |||||||
Wk 38 | 1014143 | |||||||
Wk 39 | 1015068 | |||||||
Wk 40 | 1005054 |
<tbody>
</tbody>