hi
why do u want to use vba . simple make the dynamic range and add it to the
source of pivot whenever u will add or delete the data in source sheet it
will automatically get updated
try the attachment
visit to know more abt
http://www.contextures.com/xlPivot01.html
On Sun, Jul 29, 201
Hi,
I have recorded th macro for creating pivot table with pivot chart for the
1st time and running for 2nd time gives me an error - Run time error 5
Please help in changing the *vba* code as shows in Sheet("Summary") with 1
click button to go.
Request everyone to pls have this resolved asap.