Is It Possible To Automate Pivot Table Results For A Report?

[BAFreedom]

I have a report that I do in Excel, which comes from 5 different data sources.

From them, I create 5 pivot tables, and copy and paste specific results (with specific filters, and expanding or contracting certain fields), and copy and pasting them into corresponding excel sheets.

It's a bit repetative, and I'm wondering if there is any way to automate it?

So far, I've gotten to the point of automating power query and pivot table creation. But as for selecting specific filters or field selection, I haven't gotten there yet.  Or if this is as far as I can go.

[danextian]

Automation in Excel other than those done in PQ and PowerPivot requires that one has a knowledge in VBA/Macro.

[lbendlin · Accepted solution]

In Excel start the macro recorder, then perform your usual steps.  Then stop the macro recorder and examine the resulting VBA code.