View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jason Jason is offline
external usenet poster
 
Posts: 367
Default Excel Query Parameters

Is there a way to have the input parameters to a query within Excel 2007 be
taken from cell values within the worksheet. For example, i have a query
that uses date ranges as the query criteria. But I need to go into the query
file each time and update the dates each time i run it. Rather, I would like
to have the date values taken directly from the worksheet which I am using
the query within.

Thanks-