MS Query prompt for criteria

[Jaribu]

I have an excel sheet that imports data from my accounting programme through a MS Query and ODBC connection. I want to be able to have a prompt when I refresh the data that will add criteria to the query. My problem is that I don't know how to limit the prompt to only show a list of options based on the column that I want to add the criteria to. In other words I want to add criteria to my suppliers column that will only allow a selection of one or more of the suppliers I have and not require the suppliers name to be typed in. I hope I have been clear enough, thanks for any advice/solution.query

 

[jkpieterse]

You can change your query to a parameter query and tie the query to a worksheet cell. Then you can add data validation to that cell and pull the allowed values from a separate list.
Querying External Data in Excel