I currently pull data out of our dealer management system thru Microsoft Query and then into Excel. Is there any way to build a spreadsheet so that the user can change the criteria of the query without having to go into the query builder. The change that would be needed would be something like a date range.
Something like this.
-The user enters a date in cell A2 of the spreadsheet and hits enter.
-The VBA code cuts and pastes the date into the criteria field of the query under the date field.

I think this is possible as Ive seen it done but I'm not sure how.

Thanks