Hello,
I have a pivot data which gets updated with new rows adding to the bottom. For calculation purposes i'm using GetPivotData to copy the information to another sheet.
However, the first column of my table is the date, and is in the "Row Labels" section of the firld list. If I hit = and click on a date cell it references the cell rather than using GetPivotData.
Is there a way for me to use GetPivotData or any other method to copy the dates in the pivot table to another sheet?
I have a pivot data which gets updated with new rows adding to the bottom. For calculation purposes i'm using GetPivotData to copy the information to another sheet.
However, the first column of my table is the date, and is in the "Row Labels" section of the firld list. If I hit = and click on a date cell it references the cell rather than using GetPivotData.
Is there a way for me to use GetPivotData or any other method to copy the dates in the pivot table to another sheet?
