Hi. I have several workbooks containing multiple worksheets with atleast one pivot table in each sheet. In each pivot table, I need to change the AutoSort setting to "Ascending" of a specific field, say "month".
Can someone help me write a VBA code that loops through all sheets and pivot in the active worksheet and sorts "month" in ascending order without having to call the assigned pivot table name and sheet name.
Thanks a lot! Newbie here.
Can someone help me write a VBA code that loops through all sheets and pivot in the active worksheet and sorts "month" in ascending order without having to call the assigned pivot table name and sheet name.
Thanks a lot! Newbie here.