Dear all
I have two tabs with 2 pivot tables (1= Customer Analysis, 2= Product Analysis). In pivot 1, I want to choose the customer name in a filter; this customer name should automatically be pulled by pivot table 2 as well. How to do it? Please see attached "Tool" for my data.
Moreover: what is the macro that automatically calculates all formulas fresh once I have filtered?
Thanks and many kind regards
Bookmarks