Hello - I'm trying to change the filter in a pivot table depending on a cell value in a different worksheet in the same workbook. The pivot table should update when activating the worksheet "B" with the pivot table. The pivot table contains following data - company code, year, period, account number, account description, amount. So if you change the the company code in worksheet "A" to "ABC" (cell B3) the pivot table "Accounting" would refresh the filter and set the filter "Company Code" to "ABC" in the worksheet "B". Thanks for your help.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.