I have several queries. Each week they need to shift one column right, C to D then E...W.I currently manually change C to D in all my queries and I want to simplify.A couple of examples:select B,C,AM,AN,AP,AQ where C = 'Available' order by AM limit 20andselect B,AM,AN where C = 'Available' order by AM limit 12I've tried to make the query select dynamic and reference a cell H2 with the new column select letter, so all the queries select change based on H2 value C or D ... or W.I've tried new value in H2 is D,select B,AM,AN where H2 = 'Available' order by AM limit 12select B,AM,AN where &H2& = 'Available' order by AM limit 12select B,AM,AN where &H2& = 'Available' order by AM limit 12nothing works, any suggestions?
Dynamic query select function based on a cell reference
google spreadsheets;google spreadsheets query