Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Query criteria based on a changing criteria list
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Query criteria based on a changing criteria list
meant to post this in the programming section...
"bwilk77" wrote: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Query criteria based on a changing criteria list
Glad we culd be of assistance! :-)
"bwilk77" wrote: meant to post this in the programming section... "bwilk77" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extract list of units based on error criteria to new list | Excel Worksheet Functions | |||
Extract list of units based on error criteria to new list | Excel Worksheet Functions | |||
Criteria Based List | Excel Discussion (Misc queries) | |||
Return value from list based on criteria | Excel Worksheet Functions | |||
add to a cell on a list based on two criteria | New Users to Excel |