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
cowboywmAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
cowboywmAuthor Commented:
Yes, this works fine. Thank you.
0
All Courses

From novice to tech pro — start learning today.