I have a pivot table that needs regular updating, and I am drilling down into the pivottable data by double clicking the grand total at the bottom.
Instead I would like to assign this as part of a macro.
- Think i need to use the pivot table method, but can not find anything complete to play with, I suspect this is really simple.
- Assume the pivotable is in sheet one and is called Pivottable1
Code I have tried:
Please can someone advise me of how to use VBA to automate this with a macro?
Thanks in advance