look for the Query Settings panel at the right of the screen - if it's not there, go to View then click on Query Settings.select any cell in the data table from the current query.Secondly, we need to incorporate the named range into the source for the query.
I used 'StationName' as the name of the range but you can use any name you like.
Adapting from this answer, this is a two-step process.įirstly, create a named range for the cell that stores the value you will pass to the query.
