Query criteria based on a changing criteria list

B

bwilk77

I am trying to create a query that I can update that will return values based
on criteria from a list of values. Right now I have a range defined as
=OFFSET(RangeValues!$B$2,0,0,COUNT(RangeValues!$B:$B),1) that holds the
criteria I want to query by. I would like for the query to alter its
selection criteria based on what is keyed into column B of the “RangeValuesâ€
worksheet. Hopefully the finished product would be for me to
add/delete/update values in column B, then run a macro (or refresh a query)
that will return data based on what is currently in column B.

I am connecting through an ODBC and can get the results I want if I copy and
paste the criteria values into the SQL each time they change, but I cant get
it to work based on a dynamic range of values.

I am open to try solutions in VBA or the Excel Query Builder, I'm desperate.

Any help would be greatly appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with the error: unable to filter on excel hc home school 0
MS Query Refresh Based on Dynamic Named Range 0
Use a variable in a ShapeRange.Increment 0
query criteria based on a changing list of values 2
Creating a Chart on form from selected data in query. 0
Automation of scanned file storage based on content 0
Create a chart from a table in word thats dynamic 0
Range headings 0

Top