Pivot Table - automate a process
Posted on 2013-11-05
After creating a pivot table, when you click one of the numbers to have Excel create a new worksheet showing the details of what makes up the one number, is there a way, if the underlying data changes, to automatically update these separate worksheets, or is it necessary to recreate them each time the underlying data changes? I'm assuming there's a way to automate this with macros, but I'm not a programmer and don't know the first thing on how to do this. Please advise.