Honestly, VBA isn’t that hard once you get the basics. Record a macro while you manually copy data, then tweak the code to make it automatic.
The Excel Macro Mastery blog has great starter guides.
But yeah, Power Query’s easier if you’re not into coding. Both solve how to automate excel from web data, just depends on your comfort level.
The Excel Macro Mastery blog has great starter guides.
But yeah, Power Query’s easier if you’re not into coding. Both solve how to automate excel from web data, just depends on your comfort level.