copying pivot table results to a new sheet.

A

AmyTaylor

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
 
G

Guest

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Question 2
Playing back a Pivot Table macros 2
Copy PIVOT table? 5
issue with pivot-tables 4
Pivot table multiple filters 2
Pivot Page field filter based on cell value 6
Automatically Update a Pivot Table Field Used as Column / Row 1
modified pivot table using a macro 2

Top