Macro to search and return rows of data when a number of conditions are met

Hi group,

I have a dataset that has 12 columns in sheet 2. column A has property addresses. The other 11 have corresponding expenses categorized: i.e. landscaping, electrical, plumbing, etc.

In sheet 1 I would like to have a drop down menu where if I select say landscaping (say cell A1) and have a corresponding IF function (cell A2), the macro will display all rows where the value is true.

Above my columns in sheet 2 I have an average spent for each category. So when I select landscaping in the drop down menu, cell A2 would simply switch to the average based on this IF function

I would want the macro to retrieve all rows with homes greater than equal to the value in A2 below these cells. .

I hope this makes sense.

Any and all help is appreciated.

Hi Marvin, and thank you for responding.

I dont have much experience with advanced filters, but the issue i see with using this feature is that i dont want all 12 columns in my filtered search. Looking at the filtered search criteria, i have to have the same amount of columns - if that makes sense.

Hi Marvin, and again thank you for your assistance.

I have attached a sample worksheet. In essence, I have 24 columns, one column for an expense item, and a column next to it with
corresponding z-score.

I am looking to extract those properties that exceed a parameter in two or more expense codes. (i.e. lawn care>.23, and repairs>.23 show we the property.)

This is brilliant, Mike; thank you!

Now, what if I wanted a drop down menu for category and a z-score parameter? i.e., I can switch the parameter to only maintenance, and a z-score greater than my choosing and hit run.

I imagine B1 to be drop down list and C1 to manually input a score (>.23). Also, is there a way to make this an IF formula, ie, IF A1 = ALL, it just looks for those that exceeded the zscore parameter, if blank, it defaults to the drop down category?

I hope this is not too complicated.