j8547
asked on
Excel VBA Query
I have an excel spreadsheet with data that i am look to execute a query to filter it. I want to filter the data in "Measures List" tab by executing a query on the "Input" tab. The issue is I don't know how to query on multiple variables for each criteria.
So for example, I want to be able to select High & Medium in the Impact Potential column and also a number of time frames in the "Total Time" column & also be able to search for a wildcard in the Focus Area & Responsibility columns.
Can anyone help me on this?
So for example, I want to be able to select High & Medium in the Impact Potential column and also a number of time frames in the "Total Time" column & also be able to search for a wildcard in the Focus Area & Responsibility columns.
Can anyone help me on this?
ASKER
Sorry forgot to attach the sheet. I have now.
All help is appreciated. I am looking for the VBA code for the query.
test.xlsx
All help is appreciated. I am looking for the VBA code for the query.
test.xlsx
You should populate a criteria range with your filtering data and the apply an advancedfilter to the data. See the attached workbook for an example.
Also, I've done an EE podcast on advanced filtering, which is viewable on the EE YouTube channel, which you might want to watch.
http://www.youtube.com/watch?v=0M4gePK8510
test.xlsx
Also, I've done an EE podcast on advanced filtering, which is viewable on the EE YouTube channel, which you might want to watch.
http://www.youtube.com/watch?v=0M4gePK8510
test.xlsx
ASKER
do you know how i can fit a wildcard in?
look at my criteria range on the first worksheet. I used a wildcard.
ASKER
the execute query didn't work so wasn't sure what was working
ASKER
Sorry for tall the questions just can't find how you did it. how then can I add filter 2, 3, 4 and so on.
Thanks for the help
Thanks for the help
I manually applied the AdvancedFilter. Advanced Filter is one of your filtering options.
The video shows the VBA statements that can be used to apply an advanced filter.
The video shows the VBA statements that can be used to apply an advanced filter.
ASKER
is there a way i can see the manual advanced filter you applied?
Do you see the criteria range I created on the first sheet?
ASKER
yes
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
http://office.microsoft.com/en-au/excel-help/filter-by-using-advanced-criteria-HP005200178.aspx
Michael