Dynamic pivot table

[Prem Kumar]

I recorded a macro that creates a pivot table for the data within a
particular range. The problem is that, when I add additional rows of data
and run the macro, the pivot table is not able to include the newly added
rows.

Is there a way out for this?

 

[Dave Peterson]

Debra Dalgleish explains dynamic range names here:
http://contextures.com/xlNames01.html#Dynamic