Filter Pivot Table

[Aquamore]

i have a pivot table (Pivottable1) with a pivot table field ("Part number"). I want to be able to paste a list of part numbers into range ("A2") of worksheet ("items") , then select a sheet with the pivot table and run a macro that would filter pivot table field ("Part number") making only part numbers I pasted into sheets("items").range("A1") visible.

I was able to put this code together, it does what i want, but can you please help me to change it so it works with any number of part numbers i am pasting. Thanks!

Please Login or Register  to view this content.

[Aquamore]

I've figured it out:

Please Login or Register  to view this content.