Macro on a Pivot Table run on changing data

M

MMM

Hello, I am trying to run a macro to create a pivot table on a set of data
where rows will be added. When I add rows the pivot is run only on the exact
# of rows that were originally there. I need to be able to add data and
automate it via the macro.
Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to update pivot table data range 3
Pivot Table Question 2
How I can set dynamic pivot table ONLY when I have enough data point 1
Unable to Group in Pivot Table 1
Macro to run on all files in a folder but exclude sheets with PivotTable, Pivot Charts and Charts 16
Pivot using 250,000 rows of data in Excel? 1
macro 4
Macro to add data once a Pivot Table has been refreshed 1

Top