copy a pivot table to another sheet in a macro
 

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

--
Aline

copy a pivot table to another sheet in a macro
 

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.

Aline wrote:

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

--
Aline

--

Dave Peterson