Forum Discussion
Solved
Can I create a macro that runs the recorded process on newly added rows as well?
Hello, I'm running a report once a week that has changing number of rows every week - same columns but increasing number of rows. I edit the report by adding in new columns with various formulas...
Bo_Suto Since you are in to Power BI, forget about VBA and learn PowerQuery in stead. Connect to the weekly data files (Files from Folder will probably work best), do some transformations and create an ever expanding table that feed your Power BI report.
PowerQuery may be a bit overwhelming in the beginning, but you'll love it once you get the hang of it.
Bo_Suto Since you are in to Power BI, forget about VBA and learn PowerQuery in stead. Connect to the weekly data files (Files from Folder will probably work best), do some transformations and create an ever expanding table that feed your Power BI report.
PowerQuery may be a bit overwhelming in the beginning, but you'll love it once you get the hang of it.
Thanks a lot for the very useful link Riny_van_Eekelen, really appreciate it. I've already started working my way through the different chapters 🙂