title: Column data moving to right with Excel VBA
body: <p>Below is my excl data:</p>
  
  <pre><code>A    B       c  ... F               G
  
  1   test    vb1     testing1        open
  2   test1   vb2     testing1        close
  2   test2   vb3     testing1 
  4   test3   vb4     testing1
  </code></pre>
  
  <p>I want to move F column data  to B column and shift B column data to right; so before B will be C.</p>
  
  <p>How can I do with this using Excel VBA programming?</p>