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
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
