Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Auto Update a Pivot Table

Posted on 2014-07-22
2
Medium Priority
?
328 Views
Last Modified: 2014-07-23
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
0
Comment
Question by:cowboywm
2 Comments
 
LVL 93

Accepted Solution

by:
Patrick Matthews earned 2000 total points
ID: 40213370
0
 

Author Closing Comment

by:cowboywm
ID: 40214646
Yes, this works fine. Thank you.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

783 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question