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

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.