title: Sort two columns Excel
body: <p>I have two different columns on Excel. 
  I want to create a script that will sort Column F, (Have a header) and will sort Column B based on where Column F's sort worked out. (Without affecting any other columns however!)</p>
  
  <p>So if I have  </p>
  
  <pre><code>    ColB       ColF
   1. Cat        2
   2. Mouse      1
   3. Dog        3
  </code></pre>
  
  <p>The sort will give me</p>
  
  <pre><code>    ColB       ColF
   1. Mouse        1
   2. Cat          2
   3. Dog          3
  </code></pre>
  
  <p>How can I do this? 
  I tried recording a macro of just sorting it out, but I get an error saying "The command cannot be performed with multiple selections, Click a single range and try again"</p>