Hello,
I'm new to VBA and macros and i get an error each time I try this. I want to create a pivot table from a table in the sheet called Training List and place it in a new sheet:I feel like the new sheet is causing the problem but I am unsure.
Sheets.Add
ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _
"TrainingList", Version:=6).CreatePivotTable TableDestination:= _
"Sheet1!R3C1", TableName:="PivotTable1", DefaultVersion:=6
One more thing-I have been searching for answers online, but I do not really understand the language that's used many times. That might also be part of my problem.
I'm new to VBA and macros and i get an error each time I try this. I want to create a pivot table from a table in the sheet called Training List and place it in a new sheet:I feel like the new sheet is causing the problem but I am unsure.
Sheets.Add
ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _
"TrainingList", Version:=6).CreatePivotTable TableDestination:= _
"Sheet1!R3C1", TableName:="PivotTable1", DefaultVersion:=6
One more thing-I have been searching for answers online, but I do not really understand the language that's used many times. That might also be part of my problem.