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.
Yes, that is very well possible, but it'd be helpful to see the code you have now...
Thanks for responding HansVogelaar, good to know, however, I've decided to check out PowerQuery instead...