Hello Everyone,

I need some help regarding filtering in excel, and would greatly appreciate any assistance.
I would like to be able to filter by variable criteria, and possibly by multiple variable criteria.
Allow me to explain this as simple as I possibly can

I have a workbook, in Sheet 2 I have data. In Sheet 1, I have a list of variables which I need to be filtered in sheet 2. These variables will vary in quantity, and of course the data in each cell will vary.


Now here is where I have my humble request(s).

Can I possibly have code for two separate functions:

1) For excel to register how many variables there are, and to filter each of these variables one by one (I have code that will do what I require and then reset the filter).

2) For excel to register the variables and filter all of them at the same time (multiple criteria).

I have attached a link to an example excel spreadsheet. I hope it helps!

http://www.filedropper.com/excelexample

I really appreciate any help on this.

Thank You