VBA for inserting pivot tables

[tdf2437]

I have successfully created a macro that highlights an entire data range inserts a pivot table. However, I am stumped on how to code the VBA when it comes to the following pivot table scenario.

Within the pivot table, the beginning column is for part number, and the subsequent summary columns are based upon column heading that are dates. So the pivot table would show as:

PartNumber Sum of Nov16 Sum of Nov 17 Sum of Nov 18 Sum of Nov 19

But what should I do when my data range now contains new column headings beyond these dates - they now show Nov 20, Nov 21, Nov 22, Nov 23

[IonutC]

Record a Macro and see what code the macro is showing to you, then customize the last part from the recorded macro in order to see which is the correct part in order to see the required parts,

[IonutC]

take a look here.

http://peltiertech.com/referencing-p...ranges-in-vba/