My approach to this sort of thing is some VBA that, when invoked, modifies
then executes a query. Since it's in VBA, you have great flexibility in
using worksheet selections in updating the query. I'd generally invoke the
macro either with a button in the workbook, or from another macro that would
run though a list (for example, to generate commission statements for a team
of sales reps).

"Ken King" wrote:

Is it possible to have you data query pull one or more variables from a cell
in the excel workbook and post results below?
Thanks,
Ken