Pivot Table Macro

[ccheever2009]

I am building a workbook for workers to use, to easily cut/paste a report into, and auto generate the work that has a due date of <!--= today, (macro to sort data, and put into new sheet). I built a pivot table macro, for them to use (work presents easier for task work), but I am not sure where I went wrong, each time I run this prompt appears: <font color="#333333"-->"unable to get the pivot tables property of the worksheet class", when click "debug" this is highlighted: With ActiveSheet.PivotTables("PivotTable(1)").PivotFields("Compliance").

I am new to VBA and do not understand the language, any help would be greatly appreciated.

Thanks

also using Excel 2013

 

[ccheever2009]

Apologies- Half the thread was cut out...

I am building a workbook for workers to use, to easily cut/paste a report into, and auto generate the work that has a due date of </= today. I built a macro for a pivot table but am unsure where I went wrong. Each time the macro is run this message appears: "unable to get the pivot tables property of the worksheet class", when I click "debug" this is highlighted: With ActiveSheet.PivotTables("PivotTable(1)").PivotFields("Compliance").

I am new to <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help;">VBA</acronym> and do not understand the language, any help would be greatly appreciated.

Thanks

also using Excel 2013