vba courses london - 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