Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table Calculations
Dear Friends,
How can I perform operations with the values created from a pivo table? How can I copy a Pivot Table to another location? Thanks, -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table Calculations
To copy a pivot table:
Sheets("Pivot").PivotTables(1).TableRange2.Copy _ Destination:=Sheets("Sheet1").Range("A1") To work with pivottable values, use the GetPivotData method: Dim pt As PivotTable Set pt = Sheets("Pivot").PivotTables(1) Dim rng As Range Set rng = pt.GetPivotData("Units", "Region", "Ontario") Sheets("Sheet1").Range("H1").Value = rng.Value banavas < wrote: Dear Friends, How can I perform operations with the values created from a pivot table? How can I copy a Pivot Table to another location? Thanks, G --- Message posted from http://www.ExcelForum.com/ -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Calculations | Excel Worksheet Functions | |||
Pivot Table Calculations | Excel Worksheet Functions | |||
Pivot table Calculations | Excel Discussion (Misc queries) | |||
Calculations in Pivot Table | Excel Worksheet Functions | |||
Pivot Table Calculations | Excel Discussion (Misc queries) |