Beyond Excel Parameterized Query
#############################
Video Source: www.youtube.com/watch?v=P9cUYpXIKsU
Create a Parameterized Query in Excel without Add-ins, Macros, or Formulas • NOTE: See • Parameterized Power Query . Microsoft is phasing out MS Query and replacing it with Power Query. The link shows how to do essentially the same thing with PQ
#############################