How to use parameterized query in Excel using column as parameter?
I would use a parameterized query (where IDVALUE=?), but that prompts me to input the parameter value From what you mentioned I understand you are using MS Query and you need to follow the following steps Steps to make a parameterized query in Excel use a cell value as parameter First go to the Data … Read more