Excel & MS Query

[ccepaulb]

Does anyone know how to use MS Query within Excel and link the criteris of the query to a particular cell?
I toggled the MS Query design view to SQL, but could not figure it out?

Thanks, Paul

 

[Oaktree]

Set up your query to reference your parameters with criteria such as : Between [Parameter1] and [Parameter2]

Then, right click on a cell that's part of your query and go to "parameters". Put a cell reference in "get the value from the following cell"