copy a pivot table to another sheet in a macro

  • Thread starter Thread starter Aline
  • Start date Start date
A

Aline

Hi there,

I created a macro that will copy copy the information from a created pivot
table to another sheet. I seemed ok when I recorded the macro. But there's no
pivot table on the new sheet when I run the macro. What should I do to
correct the problem?

Thanks,
Aline
 
Record another macro when you try it again?

If it fails again, you may want to describe what you did to copy the data (copy
the cells to a new sheet or copy the sheet???).

And share the code (that fails) that does the copy.
 

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 tables 1
Pasted Pivot Table looks at old sheet 1
Pivot table - undo of a macro 1
One pivot table cannot overlap another pivot issue. 1
Macro for auto refresh 1
Wait statement in macro 1
Adding to an existing Pivot Table 7
about pivot table 1

Back
Top