A great trick from Szilivia Juhasz. If you want to create a pivot table for each sales rep or each product line or each whatever, you can use the Show Pages feature. Episode Recap: There is an easy way to replicate a pivot table for each rep, product, whatever Create the pivot table To replace the
Thank you so much Detlef. I did see this. But the tables are on separate worksheets, and I was hoping to have them on the same worksheet due to having specialists analysing data in webaps. That being said; I now realize that I may be able to make this work, as I can record a macro to have all worksheets combined into one after the specialists filtered each table for the highs and lows etc. Bu,t I wonder if I can now filter each table independent of the pivot table. This may post a challenge. I will post in.few days.