pivot table with dynamic base data

[Guest]

hiya,

im trying to create a pivot table where I can change my base data (inserting
or deleting rows of data) and still have this reflected in the pivot table.

My solution was to use entire columns as my range for input to the
pivotTable, but this means including blank rows which seems to muck up the
calculations.
I cant think how else i can allow for new rows to be added to the base data
anyone got any ideas how to do this?

thanks loads for your help!

 

[Debra Dalgleish]

You can use a dynamic range as the source. There are instructions here:

http://www.contextures.com/xlPivot01.html

 

[Guest]

thankyou, works perfectly!

You can use a dynamic range as the source. There are instructions here:

http://www.contextures.com/xlPivot01.html