Is there a way for the selections in a Pivot table filter to pull from a list rather than manually choosing them?

Is there a way for the selections in a Pivot table filter to pull from a list, rather than having to manually click each one?

As an example, I have a sample attached which has the data in the "Master Table" and the list of items I would like to filter titled "Filter Selections".  In my Pivot table I have manually clicked my selections in the filter, however, could these somehow instead pull from the Filter Selections list automatically?
Sample.xlsx
daisypetals313Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

tomfarrarCommented:
See attached possible solution.  There is apparently more to this than what the example showed as it would be just as difficult to type in the items to filter on as to click the boxes in the Pivot Table.  My opinion anyway....  Good luck.  - Tom
Copy-of-Sample.xlsx
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Saurabh Singh TeotiaCommented:
Daisy,

What you are looking for can be done by a macro code to change values of pivot table basis of data entered.. Let me know if you are open to that.. ? In additional you want the macro to run automatically when you enter the value or you want to click the button to run the macro??

Saurabh...
0
daisypetals313Author Commented:
Thank you, this is a great and simple way to address my problem.  The actual file that I will be using this for has many items I need to select from as opposed to the sample which I was using for demonstrative purposes only, so know for sure that your solution is really saving me a lot of time.  Thanks again!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.