title: Search each cell in a column to find a certain value and copy value from another cell in the row the value is found in
body: <p>I have a table put together as a database. I am trying to write a macro to search a System Size column in my table to find "2500" then search a Standard column to find "Standard" then search a Category column to find "FL" I then want to copy the value from a Select Item column pertaining to the row these values were found in to another sheet. For example, the macro will search Column E (System Size) for all "2500", then it will search Column F (Standard) for all "Standard", then it will search Column G (Category) for all "FL". I then want it to copy the values from Column C (Select Item) for every line that meets these requirements and paste it to another sheet. Following is the code I have so far but I can only get it to search one cell and not the entire column. There is probably a better way to go about it but this is the only way I have found that works.</p>
  
  <pre><code>Sub ImDoingMyBest()
  '
  ' ImDoingMyBest Macro
  '
  
  '
      If Sheets("Database").Range("E2").Value Like "*2500*" Then
      Sheets("Database").Range("C2").Copy
      Sheets("Quote Sheet").Select
      Range("B26").Select
      Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
          :=False, Transpose:=True
  End If
  End Sub
  </code></pre>