B
bwilk77
I am trying to create a query that I can update that will return values based
on criteria from a named range (or a list of values). Right now I have a
named range “ValueList†that is defined as
=OFFSET(RangeValues!$B$2,0,0,COUNT(RangeValues!$B:$B),1). 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 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.
Any help would be greatly appreciated.
on criteria from a named range (or a list of values). Right now I have a
named range “ValueList†that is defined as
=OFFSET(RangeValues!$B$2,0,0,COUNT(RangeValues!$B:$B),1). 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 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.
Any help would be greatly appreciated.