Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Pivot Filter by cell value in different worksheet

Status
Not open for further replies.

TUT1994

IS-IT--Management
May 18, 2010
3
US
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.
 
Hi,

This is something that can only be accomplished with a macro, using the Worksheet_Change Event.

It would be best if you repost your question in Forum707, where VBA (macro) questions are addressed.

Skip,
[sub]
[glasses]Just traded in my OLD subtlety...
for a NUance![tongue][/sub]
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein
 
Thank you SkipVought- I will post this question there.
 
Check your new thread in Forum707.

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

Part and Inventory Search

Sponsor

Back
Top