title: Search for a value and move it to another spreadsheet
body: <p>I have a little problem using Excel 2010. The problem is simple but I think I start in a wrong direction. Let's say I have a document with the following structure:</p>
  
  <p><div class="snippet" data-lang="js" data-hide="false">
  <div class="snippet-code">
  <pre class="snippet-code-html lang-html prettyprint-override"><code>&lt;table&gt;
    &lt;thead&gt;
      &lt;th&gt; Col A&lt;/th&gt;
      &lt;th&gt; Col B&lt;/th&gt;
      &lt;th&gt; Col C&lt;/th&gt;
    &lt;/thead&gt;
      &lt;tr&gt; 
        &lt;td&gt; NONE&lt;/td&gt;
        &lt;td&gt; TEST&lt;/td&gt;
        &lt;td&gt; NONE&lt;/td&gt;
        &lt;td&gt; TEST2&lt;/td&gt;
        &lt;td&gt; TEST3&lt;/td&gt;
        &lt;td&gt; TEST4&lt;/td&gt;
     &lt;/tr&gt;
    
    &lt;tr&gt; 
        &lt;td&gt; NONE&lt;/td&gt;
        &lt;td&gt; TEST&lt;/td&gt;
        &lt;td&gt; NONE&lt;/td&gt;
        &lt;td&gt; TEST2&lt;/td&gt;
        &lt;td&gt; TEST3&lt;/td&gt;
        &lt;td&gt; TEST4&lt;/td&gt;
     &lt;/tr&gt;
    
    &lt;tr&gt; 
        &lt;td&gt; TEST&lt;/td&gt;
        &lt;td&gt; TEST&lt;/td&gt;
        &lt;td&gt; NONE&lt;/td&gt;
        &lt;td&gt; TEST2&lt;/td&gt;
        &lt;td&gt; TEST3&lt;/td&gt;
        &lt;td&gt; TEST4&lt;/td&gt;
     &lt;/tr&gt;
    
    &lt;tbody&gt;
    &lt;/tbody&gt;  
    
  &lt;/table&gt;
    </code></pre>
  </div>
  </div>
  </p>
  
  <p>I want to search for <code>NONE</code> and move it to another spreadsheet. I want to do this with formula. I tried with SEACH but I don't know how to move it to another spreadsheet.</p>