title: VBA - Macro That Finds Specified Header, Filters Values in Various Sheets where Column Locations Change
body: <p>Trying to figure out a Macro that will do the following:</p>
  
  <p>1) Find a specified header (ie: "status")
  2) Filter this column to a specified value (ie: "discontinued")
  3) Once filtered, find another specified column (ie: "replaced with")</p>
  
  <p>The challenge for me is I can't figure out how to set it so the column "Field" is variable to the sheet its on.</p>
  
  <p>I have multiple files that have the "status" header in different locations, (one file has it in column c, another in column f, etc). Is there a way to have excel find that specific column in each sheet is and filter it?</p>