Play-by-Play U

Play-by-Play U

Share this post

Play-by-Play U
Play-by-Play U
Spotting Boards 104: Creating dropdown menus to change multiple tables at once
Spotting Board U

Spotting Boards 104: Creating dropdown menus to change multiple tables at once

Today's magic Google Sheets function attaches every table you scrape to a single cell

Aug 25, 2024
∙ Paid
3

Share this post

Play-by-Play U
Play-by-Play U
Spotting Boards 104: Creating dropdown menus to change multiple tables at once
Share

As we saw in Lesson 3, there is virtually no limit to how large your dropdown menu in Google Sheets can be. The implications of this are enormous. Your dropdown menu can include every team on your schedule, or every team in the country for that matter, and you can set your web scraping formulas up so that they change based on the value you select in your dropdown menu.

But in order to do this seamlessly for multiple tables at the same time, you’ll need the help of several different functions, which is what today’s lesson is all about. Some of these functions and formulas can get a little complicated, so today’s lesson is the first of many where we’ll start to put A.I. to work for us.

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