Try this:
Sub CreatePivot()
Dim wksPivotSheet As Worksheet
Dim wksWest As Worksheet
Set wksPivotSheet = ThisWorkbook.Worksheets.Add
Dim oPC As PivotCache
Dim oPT As PivotTable
Dim oWS As Worksheet
Set oWS = ActiveSheet
Set oPC = ActiveWorkbook.PivotC
hi Ansari,
I am bit new to vba coding as this pivot source data is within sheet as per
attached sheet .
*my query is *
if i have data in different sheet please advise.
can you please help to provide this below listed steps code
1) to copy particular sheet from one existing workbook to
