I've built a query in excel through the Workbook Connection section that pulls data from our tables into an excel workbook. I have the query in the command text of the Connection Properties. I would like to update my query based on values contained in cells withing my excel sheet. It could be a cell or range of cells for what I"m needing.

Here is my query:

WHERE (ASPOLICY.POLICYNUMBER = 'AV******')
AND (ASTRANSACTION.TRANSACTIONNAME = 'AnniversaryProcessing')
ORDER BY ASACTIVITYMATH.MATHNAME ASC

Would there be any way to update the policy number in my where clause with a cell value or range of cells? (Preferably range of cell)