Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy data from pivot table using relative reference
Hello
I have created a pivot table, and I would like to extract data from it for further calculations (basically, summing, subtracting, etc the columns that are in the pivot table). If I use "getpivotdata", or simply refer to the cell with the "=" sign, excel returns the value in that cell with an absolute reference. I need relative references, so I can copy down the whole length of the table. If there is an easier way to do this, that would be nice as well. Thank you |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Relative reference Chart data | Charts and Charting in Excel | |||
Relative references for condtional formatting within a Pivot Table | Excel Worksheet Functions | |||
Copy a relative reference formula from one sheet to another. | Excel Discussion (Misc queries) | |||
Is there a way to copy a pivot table using a different data set? | Excel Discussion (Misc queries) | |||
Formula to get Relative Folder Reference to data in another file? | Excel Worksheet Functions |