VBA Macros Pivot Tables

[ccheever2009]

I am trying to take a report out of our EMR, post into Macro enabled workbook, divide the work with anything of a date needed (column heading) formula for anything with a date = today or before. I use a macro to cut that data and put into new sheet. From there I created a pivot table macro, but every time I run I get "unable to get the pivottables property of the worksheet class", when click "debug" this is highlighted: With ActiveSheet.PivotTables("PivotTable(1)").PivotFields("Compliance").

Any help is greatly appreciated.

Thanks