Hi All,
In need of your help. I'm trying to create a macro that automatically create a pivot table from a sheet. I'm having trouble in capturing new saved entry. I think i need help with R1C1:R48C13 since 49th and the rest of the rows are not captured. Please help
ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _
"QA Error Correction Tracker!R1C1:R48C13", Version:=xlPivotTableVersion14). _
CreatePivotTable TableDestination:="Pivot!R3C1", TableName:="PivotTable1" _
, DefaultVersion:=xlPivotTableVersion14
Thank you
Bryan
In need of your help. I'm trying to create a macro that automatically create a pivot table from a sheet. I'm having trouble in capturing new saved entry. I think i need help with R1C1:R48C13 since 49th and the rest of the rows are not captured. Please help
ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _
"QA Error Correction Tracker!R1C1:R48C13", Version:=xlPivotTableVersion14). _
CreatePivotTable TableDestination:="Pivot!R3C1", TableName:="PivotTable1" _
, DefaultVersion:=xlPivotTableVersion14
Thank you
Bryan
