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


--
Chard
------------------------------------------------------------------------
Chard's Profile: http://www.excelforum.com/member.php...o&userid=37200
View this thread: http://www.excelforum.com/showthread...hreadid=569112