refresh a new worsheet on pivot table refresh

A

aj70000

Hi,

I am a newbie on excel pivots. I would like to copy the data from a
pivot table in a new worksheet and refresh it as and when the pivot
gets refreshed. Any insight would be very helpful.
I am using excel 2003.

Thanks
AJ
 
Top