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!


  • Content count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About GlobeTrotter

  • Rank

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. 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!