tag:blogger.com,1999:blog-28492262.post1283303684811496941..comments2023-12-27T22:22:25.151-08:00Comments on VBA Tips & Tricks: Create Additional Pivot Table using Excel VBA (from Existing PivotCache)Unknownnoreply@blogger.comBlogger4125tag:blogger.com,1999:blog-28492262.post-90860626314808523962015-04-05T22:09:37.589-07:002015-04-05T22:09:37.589-07:00The code is missing the Set keyword in two places....The code is missing the Set keyword in two places...<br /><br />Set oPC = oWS.PivotTables(1).PivotCache<br />Set oPT = oPC.CreatePivotTable(oWS.[J1], "Pivot From Existing Cache", True)<br /><br />Jerry Sullivannoreply@blogger.comtag:blogger.com,1999:blog-28492262.post-8890128844387115502012-12-07T21:14:19.870-08:002012-12-07T21:14:19.870-08:00how can create a macro in pivot table any were.how can create a macro in pivot table any were.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-28492262.post-38852671432252716292012-05-21T15:37:21.358-07:002012-05-21T15:37:21.358-07:00I can't run this code...is it incomplete?I can't run this code...is it incomplete?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-28492262.post-1599128939313955462010-05-11T05:35:20.744-07:002010-05-11T05:35:20.744-07:00how can i create a pivot table based on two existi...how can i create a pivot table based on two existing pivot tables.. its like putting both table datas together?Anonymousnoreply@blogger.com