Hi, hope someone can help out with this one.
I have a macro that spools thru the available fields in a pivot table,
what I want to do is copy the results into a new worksheet where the
data would become values only. Is this possible?
Thanks for your help

Amy xx


--
AmyTaylor
------------------------------------------------------------------------
AmyTaylor's Profile: http://www.excelforum.com/member.php...o&userid=20970
View this thread: http://www.excelforum.com/showthread...hreadid=374129