Jump to content
News Ticker
  • Welcome to the Community
  • Use the forum to troubleshoot your Excel & VBA Problems
  • We will be launching a new website soon! www.ExcelWTF.com/Learn ! Join us to learn VBA from the ground up!
  • 0
GlobeTrotter

Linking a pivot table report filter to a data validation list in another sheet

Question

Hi All,

On sheet 1 I have a pivot table full of data, and sheet 2, I have built a model that is sorted through a data validation list. When I change Sheet 2 (the data validation cell), I would like Sheet 1, the pivot table report filter to mirror the selection I made in Sheet 2.

To illustrate, sheet 2 has data validation list of team names, e.g. Manchester United, Chelsea etc.

When I select Manchester United in sheet 2, I want my pivot table on sheet 1 to automatically select Manchester United as well, and show me only the data for Manchester United.

I have been trying to figure this out for 2 days and still cannot get it to work!

Any help would be greatly appreciated!

Share this post


Link to post
Share on other sites

0 answers to this question

Recommended Posts

There have been no answers to this question yet

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×