William C Johnson
asked on
Auto Update a Pivot Table
The attached file contains a pivot table showing the total number of open and closed items. As I add a new row to the table via a macro, how do I write a macro so the new row is included in the pivot table as it refreshes. I have tried naming ranges but that does not work. Pivot tables seem to be very restrictive and always require operator intervention.
Thanks,
Bill
Filter-Sample.xlsm
Thanks,
Bill
Filter-Sample.xlsm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER