Play-by-Play U

Play-by-Play U

Share this post

Play-by-Play U
Play-by-Play U
Spotting Boards 103: How to make the data you scrape dynamic
Spotting Board U

Spotting Boards 103: How to make the data you scrape dynamic

Create dropdown menus and color code superlative stats so they stand out

Aug 24, 2024
∙ Paid
4

Share this post

Play-by-Play U
Play-by-Play U
Spotting Boards 103: How to make the data you scrape dynamic
1
Share

In our last lesson, we learned about how to use the multiple functions together that scrape data off of tables on internet web pages and looks up data on those tables. This accomplishes several objectives. It means that you could get the data in multiple cells to change with a single prompt, which can be multiplied out as many times as you would like.

Today, we’re going to add one more function into the mix, but mostly focus on three crucial options within the navbar of Google Sheets. They are:

This post is for paid subscribers

Already a paid subscriber? Sign in
© 2025 Tony Castricone
Privacy ∙ Terms ∙ Collection notice
Start writingGet the app
Substack is the home for great culture

Share