pull down to refresh
Try this to automate step 2. For $12/y the PRO version could be really useful and can save you a lot of time (and clicks!)
reply
pull down to refresh
Try this to automate step 2. For $12/y the PRO version could be really useful and can save you a lot of time (and clicks!)
I could certainly improve the workflow and automate a lot more if I wanted a live dashboard or to do this regularly, but without any API this is what was used to get the job done for now:
If I was to make this a continued process, I would automate Steps 2 and 5 - making sure the data got pushed to Tableau or something as capable. For a one-off exercise like this however, it's more than sufficient.
And next time I want to click a button 390+ times to get an updated view, I can simply paste the data over the existing spreadsheet data and all the pivot tables automatically update.