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!