Hello,

Firstly, thank you all for your help in the past, I'm a long time lurker, first time poster.
Very impressed with the macros and answers on this forum. All of my past attempts are crude and simple (done via recording), but it gets the job done.
Unfortunately I am unable to solve my current dilemma with my limited knowledge on macros.

I am trying to get my buying guide spreadsheet to display all rows based on 2 criteria; the first is a keyword search and the second is from a drop down list of Australian states.
The keyword search is based on a product or service, and could be something like "enviro* assess*". On my data tab, i have described these services based on the vendor's capabilities, on the data tab in Column P.
The drop down list contains a list of Australian states, the data validation is in the Lists tab, and corresponds to the column A in the data tab.
Please see my sample file as attached.

I found an elegant macro in the below page and have tried to amend it to suit my needs, to no avail.
http://www.excelforum.com/excel-prog...filtering.html

I would greatly appreciate if someone could help modify this macro with the following changes
1. Instead of having a popup, could this please be changed to analysing the data based on the information in the Results tab, cells F3 and I3.
2. the search to be done first on the State, then by keyword (in the example on the attached file, search by VIC in Data! Column A, then for anything with enviro* in Data! column P
3. display all rows in the Results tab, from row 6 onwards

I would greatly appreciate if I could just type in a keyword (with or without wildcard), select a state, then click on the button to display all of the vendors from my data tab, who are capable of performing the requested service in the relevant state.

Many thanks in advance!!
KenzoBuying guide test.xlsm