Macro on a Pivot Table run on changing data
 

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!

Macro on a Pivot Table run on changing data
 

Change the data tables source range to a dynamic named range. Check out this
link on creating such a range...

http://www.cpearson.com/excel/named.htm
--
HTH...

Jim Thomlinson


"MMM" wrote:

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!