I am creating a dashboard from similar data sets. I cannot combine the data sets because it will throw off the final analysis.
Both data sets have "plan" and "tier" fields. One data set has an extra field called "description."
Other people will be using this spreadsheet. I have drop down lists in cells B1:B3 that allow the user to choose a plan, tier, and description respectively.
I want to use the inputs from B1:B3 to filter multiple pivot tables on the same spreadsheet. What is the appropriate code to enter to manipulate the report filters in this way? I have looked for the past 2 hours and cannot find anything. Any help will be very appreciated.