Update Excel query value from Sheet

[jribeiro]

Hi everyone!

I connected one Workbook to a database to Microsoft query. So far so good.

My problem is that that query uses dates to sort the data and I wanted to have Microsoft Query fetch the value for the date in a Sheet on the workbook.

Meaning that in the CRITERIA FIELD I would have something like:

DATE
Cells(AA1)

Is this even possible?? I've attached a photo to help illustrate my problem.

Thanks in advance

[T-J]

In MS Query criteria grid you specify parameters by enclosing them in square brackets with an optional text prompt:

The example below will return order dates between the 2 dates entered.
Criteria Field: OrderDate
Value: Between [first date] And [second date]

This example will return order dates on or after the date entered.
Criteria Field: OrderDate
Value: >=[enter date]

Right-click the returned data on the Excel sheet and select Parameters. From there you can choose a cell for each parameter.

[jribeiro]

Perfect! Thanks so much