Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to Copy Pivot Table Data to Another Worksheet in Same Workbo | Excel Worksheet Functions | |||
macro - copy/add to another sheet | Excel Discussion (Misc queries) | |||
Pivit table- cell on spread sheet referencing pivot table field | Charts and Charting in Excel | |||
Macro to copy a sheet and name it | Excel Discussion (Misc queries) | |||
I need to copy table from one sheet to anothe | Excel Worksheet Functions |