Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to Solution.
In Excel start the macro recorder, then perform your usual steps. Then stop the macro recorder and examine the resulting VBA code.
Automation in Excel other than those done in PQ and PowerPivot requires that one has a knowledge in VBA/Macro.
Proud to be a Super User!
In Excel start the macro recorder, then perform your usual steps. Then stop the macro recorder and examine the resulting VBA code.
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |