Pivot tables
How do I link 2 pivot tables together? ie. If I filter on one pivot table I
would like the other pivot table to filter to the same criteria. All data is from the same source. thanks, Carrie |
I suggested the following, when you posted this question a few days ago:
'============================ There's a sample file here that changes the page field in all pivot tables, when the master pivot table is changed: http://www.contextures.com/excelfiles.html Under Pivot Tables, look for 'Change Page Field' '====================== Do you try this and have problems? carrie wrote: How do I link 2 pivot tables together? ie. If I filter on one pivot table I would like the other pivot table to filter to the same criteria. All data is from the same source. thanks, Carrie -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
All times are GMT +1. The time now is 12:21 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com