Use Cell Value to Change Pivot Filter

Hello,

Need a little help....I feel very close to my solution. If you take a look at my code you will see what I'm trying to do.

Very simple solution, I'm sure a minor tweak would do.

Thanks in advance!

Hi PCI,

Thanks for the response! Sorry for the lack of explanation. My goal is to type any item number into cell M24, run the macro, and have it replace the process of going to the filter in B1 where my pivot table is and pasting it there. My list of items will grow to be thousands so I'd like to be able to type an item number there, click the button and have my charts on that page reflect the new filter.

Also if anyone knows of a way to filter for multiple criteria (more than one item number), that'd be superb as well!

Thanks for the help!

Justin