Hello I am new and this is my first thread here. I would like to automate a pivot table that will create sheet and my pivot table will populate there. For example I have database on Sheet1 and I would like to create pivot table based on the sheet name like "Summary 2009",I have my code that will create pivot table but how can I filter or declare a code to create pivot table another sheet and not on a sheet1 here is my piece of code.Hope you can help me
.Many thanks to all
.Many thanks to all
Code:
Dim WSD As Worksheet
Dim strField As String
Dim Sh As Worksheet
Dim PTCache As PivotCache
Dim PT As PivotTable
Dim PRange As Range
Dim FinalRow As Long
Dim FinalCol As Long
'this code is the name of my active sheet
Set WSD = Worksheets("Sheet1")
