I have 200 plus worksheet and each have the same pivot tables, I need to sort the pivot field in ascending order and I was wondering how I can do this via a macro or vb. I tried recording a macro but it errors out.
Keyboard Shortcut: Ctrl+a
'
ActiveSheet.PivotTables("PivotTable101").PivotFields("CPT").AutoSort _
xlAscending, "CPT"