Filter Pivot by Cell Value in different worksheet

[TUT1994]

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.

 

[SkipVought]

Hi,

Have you ever done any VBA programming? You're gonna have to code a Worksheet_Change event in sheet A.

BTW, we're eventually coming down to...

  Worksheets("B").PivotTables("Accounting").PivotFields("Company Code").CurrentPage = Worksheets("A").Cells(3, "B").Value

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein