Macro to auto create Pivot table

[daveb86]

I currently have 3 columns eg: Column1, Column2 and Column3

Im trying to get a Macro to auto pivot this information

Column1 would be the left hand side info
Coulmn2 would be along the top
Column3 would be the data in the body of the table

However when i try to execute this i get the error below and not all columns are shown

"Unable to get the PivotFields property of the PivotTable Class"

If anyone could help me to achieve this perfectly that would be a great help

My current code consists of

Please Login or Register  to view this content.

[adyteo]

which line is highlighted when the error occurs?

how was this code created:record macro or manually?

[daveb86]

which line is highlighted when the error occurs?

how was this code created:record macro or manually?

Hello there

This line is > With ActiveSheet.PivotTables("PivotTable2").PivotFields("SKU")

For some reason when it gets to the pivot chart sheet the first 2 headers are missing which are what is in Columns A and B

This code was created through recording a macro

Thanks Dave

[daveb86]

Is anyone able to assist with this please ?

Thanks

Dave