Hello all, I have learnt before that 2 pivot tables can be linked (so changing a filter selection on one - also changes on the other) and I have learnt that you can chane a pivot table filter by referencing something typed in a Cell.

What I need to do now, is change a filter in a pivot table (Column Heading) based on a cell.

The column heading is PN (for part number) and I want to type a part number into cell (I2 on Sheet2 for example), and the pivot table select the typed part number within the column label filter.

The pivot table is PivotTable1 and the worksheet it is on is Sheet2.

I also have PivotTable2 on sheet 2, with PN again in the column labels filter. If this could also change when the part number is typed in cell I2 then even better.

Thanks in advance for any help