Yasmina has attended:
Excel VBA Intro Intermediate course
How do I create a pivot table?
pivot table
RE: How do I create a pivot table?
Yasmina,
The best way to start is to create the pivot table you want, using the Pivot Table Wizard (on the Data menu), recording a macro as you go. You can then tidy up the recorded code---for example to pick up named ranges.
For example, this creates a pivot table on a new sheet called "PT Orders":
Sub Pivot_Table_Orders()
'
' Modified version
'
Dim pvc As PivotCache