title: Print rows based on criteria?
body: <p>I'm a bit new to excel but so far I have gotten the hang of some of the formulas. What I did is created a countifs formula to search for certain criteria in the columns. However, what I want to do is based off of what I searched for using countifs, I want to display the rows that the countifs searched for in a separate sheet. For example, if I searched through column A and found that 3 rows in column A had the word "Hello" in them, I would want to print out the rows that have the word "Hello" in column A in them. Is there a simple or automated way to do so? I would not like to do it manually through filters. If anyone could help that would be great! Thanks!</p>
  
  <p>An example of rows and columns would look like this:</p>
  
  <pre><code>Animal    Owner    Phrase
  Cat       Jack     Hello
  Dog       Jill     Bye
  Elephant  Henry    Hello
  </code></pre>
  
  <p>In this case I would use countifs to look for "Hello" which would display the rows for in a separate sheet.</p>
  
  <pre><code>Cat       Jack     Hello
  Elephant  Henry    Hello
  </code></pre>
  
  <p>If anyone has any suggestions on how to do so, that would be greatly appreciated. Thanks!</p>