title: Copying rows to another worksheet based on a search on a grid of tags
body: <p>I am having a problem with Excel that I was hoping someone could help me with.</p>
  
  <p>I have a table where between columns K &amp; Q are a number of tags. What I would like to do is have a function or a macro or something that will allow me to look within all these tags and copy any rows that contain a specific word to another worksheet.</p>
  
  <p>e.g.</p>
  
  <pre><code>       I           J        K          L         M           N              O     etc. 
  1      blah        blah     funding    blah      blah        blah           blah
  2      funding     blah     blah       blah      blah        blah           blah
  3      blah        blah     blah       blah      blah        blah           blah
  4      blah        blah     blah       blah      blah        blah           blah
  5      blah        blah     blah       blah      blah        funding        blah
  6      blah        blah     funding    blah      blah        blah           blah
  </code></pre>
  
  <p>There is other information in columns A to H that I will also need to copy across, but do not want to include in the search. So in this scenario, I would like to be able to search for the tag 'funding' and therefore copy rows 1, 2, 5 &amp; 6 to a different worksheet.</p>
  
  <p>Is this possible?</p>