title: excel search engine using vba and filters?
body: <p>I am using the following vba code to filter my rows in excel based on the value in my cell C5</p>
  
  <pre><code>Sub DateFilter()
      'hide dialogs
      Application.ScreenUpdating = False
      'filter for records that have June 11, 2012 in column 3
      ActiveSheet.Range("C10:AS30").AutoFilter Field:=1, Criteria1:="*" &amp; ActiveSheet.Range("C5").Value &amp; "*"
      Application.ScreenUpdating = True
  End Sub
  </code></pre>
  
  <p>My excel columns look like:</p>
  
  <pre><code>A            B          C             
  Gold         XXX        Manchester
  Silver       TTT        London
  Black        ZZZ        Scotland
  White        WWW        Wales
  </code></pre>
  
  <p>So if I typed in the word 'Gold' in my cell C5 and ran the macro my rows get filtered and only the following would be showing:</p>
  
  <pre><code>Gold        XXX       Manchester
  </code></pre>
  
  <p>However, now I want to be able to filter my rows by putting a value from either column a, b or c into my cell c5 and filter the rows.</p>
  
  <p>So if I enter the letters 'TTT' into cell c5, this will filter my rows like so:</p>
  
  <pre><code>Silver       TTT       London
  </code></pre>
  
  <p>And if I type in Wales into cell c5 It filters my rows like:</p>
  
  <pre><code>White      WWW    Wales
  </code></pre>
  
  <p>The other thing I want to do is be able to filter my rows based on a multiple search criteria so if I put a combination of a value from column a, b and c in my cell c5 like so:</p>
  
  <pre><code>White  WWW Wales 
  </code></pre>
  
  <p>Then I end up with the following filtered result:</p>
  
  <pre><code>White      WWW       Wales 
  </code></pre>
  
  <p>Please can someone show me how I would be able to do this? Thanks in advance </p>