Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Creating pivot table to Existing worksheet
Here's all the relevant information:
a) I was able to successfully create a pivot table, in a newly created tab named "Sheet2". This pivot table is contained in A:E, was copied and the duplicate of that pivot table pasted into I:M. b) Next I attempted to generate a new pivot table, using a new data range, to the "Existing worksheet" at P:V. When running the VBC code for the new pivot table I get the error "Run Time 1004: Unable to get the Pivot Table Property of the Worksheet class" The broken VBA code is below: Quote:
Any help would be greatly appreciated!!! :) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
adding a pivot table to an existing worksheet- HELP!! | Excel Discussion (Misc queries) | |||
Creating a Pivot Table with data in more than one worksheet | Excel Worksheet Functions | |||
Pivot Table Creating New Columns that Subtract Two Existing Columns | Excel Discussion (Misc queries) | |||
Creating new worksheet from existing | Excel Discussion (Misc queries) |