Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
pivot table
hi...
i am creating a pivot table as many times there are sheets in the workbook. each pivot needs to be created in a new sheet. i am able to a new sheet. but my pivot is not geting created ..nor it gives any error. here is a part of a code: For i = 1 To totSheets Set NewSheet = Worksheets.Add (befo=ActiveWorkbook.Worksheets.Item(1)) NewSheet.Name = "Summary " & arrWkShNames(f) tmpStr = "Summary " & arrWkShNames(f) Sheets("Summary " & arrWkShNames(f)).Select ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatab ase, SourceData:= _ arrWkShNames(f) & "!R" & rng1.Row & "C1:R" & arrLRow(i) & "C" & rngUnderCost (i).Column).CreatePivotTable TableDestination:="[" & fileSaveName & "]" & tmpStr & "!R3C1", TableName _ :="PivotTable2", DefaultVersion:=xlPivotTableVersion10 thanks a lot |
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) | |||
Print Pivot Table headers on pages with Pivot Table | Excel Worksheet Functions | |||
Filter lines with Pivot table and non pivot table columns | Charts and Charting in Excel | |||
Filter lines containing pivot table and non pivot table data | Excel Worksheet Functions | |||
Help required with setting up a pivot table with the source on sheet1 to have the pivot table created on sheet called "report" | Excel Programming |