title: VBA Multiple Criteria / Variable Filter
body: <p>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 </p>
  
  <p>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.</p>
  
  <p>Now here is where I have my humble request(s). </p>
  
  <p>Can I possibly have code for two separate functions:</p>
  
  <p>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).</p>
  
  <p>2) For excel to register the variables and filter all of them at the same time (multiple criteria).</p>
  
  <p>I have attached a link to an example excel spreadsheet. I hope it helps!</p>
  
  <p><a href="http://www.filedropper.com/excelexample" rel="nofollow">http://www.filedropper.com/excelexample</a></p>
  
  <p>I really appreciate any help on this.</p>
  
  <p>Thank You </p>