auto pivot tables and charts ?
 

Hi, I am looking for a some help with some code.

I have several macros whose end product is to create a new range o
data, which I then want to pivot table and graph from the pivot table.

A) is there a way to automatically create a pivot table whenever th
data has been written to the sheet - the thing is that the range wil
be different each time the sheet is updated.

B) can you automatically create a sheet based on this pivot table ?

All advice gratefully received. Thanks
Scott

--
scottwilson
-----------------------------------------------------------------------
scottwilsonx's Profile: http://www.excelforum.com/member.php...fo&userid=1112
View this thread: http://www.excelforum.com/showthread.php?threadid=26460