Pivot Table - Adding New Data

[Chard]

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]

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 here:

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

[Chard]

Thanks, Debra - I'll give that a go and let you know if I come unstuck.

Chard