Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with Pivote Table
I have just recorded a macro to create a pivote table. The problem is,
everytime i run the macro a new worksheet is created. What do I have to change in the macro code to direct the pivote table to be created in an exiting worksheet (pre-named) instead of setting up new worksheet everytime I activated the macro button. Many thanks, Ola. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with Pivote Table
CODE (substitute appropriate range, sheet name, workbookname, PivotTableName):
ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatab ase, SourceData:= _ "sheet1!R1C1:R10C10").CreatePivotTable TableDestination:= _ "[book1.xls]SheetName!R1C1", TableName:="PivotTableName", _ DefaultVersion:=xlPivotTableVersion10 -or- while recording the macro: in Step 3 of 3 in the Pivot Table wizard, select "Existing worksheet" and choose where you want the pivot table to go -- Rich "Ola2B" wrote: I have just recorded a macro to create a pivote table. The problem is, everytime i run the macro a new worksheet is created. What do I have to change in the macro code to direct the pivote table to be created in an exiting worksheet (pre-named) instead of setting up new worksheet everytime I activated the macro button. Many thanks, Ola. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multiple pivote charts in one sheet | Excel Discussion (Misc queries) | |||
entry removed from source table remains in pivot table pull down | Excel Worksheet Functions | |||
Is it possible to import external data into existing pivote table | Excel Discussion (Misc queries) | |||
Excel Pivot Table Plugin? (crosstab to data table) | Excel Discussion (Misc queries) | |||
PIVOT TABLE - Summary Table into a Databasae Table. | Excel Worksheet Functions |