I have the same question:

When my pivot table is refreshed, i want to copy the cells in column A to
another workbook\worksheet, after the cells in column C, how to do so?

Any expert can help here?

"AmyTaylor" wrote:


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