title: AutoFilter - Dynamically change in Filter Criteria
body: <p>I'm having the same kind of question as in this link - 
  <a href="https://stackoverflow.com/questions/7764655/get-autofilter-sort-criteria-and-apply-on-second-sheet">Get AutoFilter sort criteria and apply on second sheet</a></p>
  
  <p>I've gone thru the link but not able to get the required output.</p>
  
  <p>I've the filtered criteria in Sheet1 (which we can change as required) on one of the column values (eg: col 10) and now based on what ever the data in column 10 which are shown based on the filter criteria, I want to filter on sheet2 with the data in sheet 1. </p>
  
  <p>I have seen that many of them using with static values in ARRAY as shown but how can I autofilter dynamically changing values in the sheet1 and filtering in Sheet2. Please advise</p>
  
  <p><code>
  .AutoFilter Field:=10, Criteria1:=Array("value1", "value2"), Operator:=xlFilterValues
  </code></p>