If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|