To ensure that new rows or columns are included in the pivot source
data, you can base the pivot table on a dynamic range. There are
instructions he

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


Chard wrote:
Hello

When creating a pivot table to group data by month I have to specify
the exact range on the worksheet

How do I overcome this problem if I am constantly adding new data to
the end of the list?

Many thanks

Chard




--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html