E eds1001 New Member Nov 6, 2012 #1 Lets say that you have two pivot tables. If you change or select an item from a filter dropdown(A2)in PTable 1, that you can have the PTable2 cell A2 change as well?
Lets say that you have two pivot tables. If you change or select an item from a filter dropdown(A2)in PTable 1, that you can have the PTable2 cell A2 change as well?
K keymaster New Member Nov 7, 2012 #2 If you have Excel 2010, set up slicers and use them. This way you can update one and the other pivot updates too. More on this here: http://chandoo.org/wp/2010/12/08/dynamic-dashboard-video-tutorial/ In earlier versions, you can set up a simple macro that does it. More on this here: http://chandoo.org/wp/2011/04/27/update-report-filter-macro/
If you have Excel 2010, set up slicers and use them. This way you can update one and the other pivot updates too. More on this here: http://chandoo.org/wp/2010/12/08/dynamic-dashboard-video-tutorial/ In earlier versions, you can set up a simple macro that does it. More on this here: http://chandoo.org/wp/2011/04/27/update-report-filter-macro/
A Anant Chirmade New Member Aug 17, 2014 #3 Hi Ed, Please see this article regarding, connecting slicers. http://dailydoseofexcel.com/archives/2014/08/16/sync-pivots-from-dropdown/
Hi Ed, Please see this article regarding, connecting slicers. http://dailydoseofexcel.com/archives/2014/08/16/sync-pivots-from-dropdown/
