title: Macros for copy data from one sheet to another by conditional formula
body: <p>I am working on a project where in excel there are huge data. Each data have number for rows and columns. I want to move this data by condition to there respective sheets.</p>
  
  <p><strong>Excel workbook:</strong> </p>
  
  <p>First sheet name is <code>Shortage Report</code>, it has all the data that should move to there respective sheet by state wise.</p>
  
  <p><strong>Example:</strong> </p>
  
  <p><code>Shortage Report</code> column <code>A</code> have Cities Name: </p>
  
  <pre><code>Mumbai
  Bangalore
  Hyderabad
  Kochi
  Chennai
  ..... so on.
  </code></pre>
  
  <p>and Column <code>D</code> have place short name. i.e. </p>
  
  <pre><code>Mumbai - MU
  Bangalore - BU 
  etc.
  </code></pre>
  
  <p>I want to <strong>move data using conditional formula</strong>:</p>
  
  <ul>
  <li>If column <code>A = Mumbai</code> and column <code>D = MU</code> then move to sheet <code>MU</code>.</li>
  <li>If column <code>A = Bangalore</code> and column <code>D = BU</code> then move to sheet <code>BU</code>.</li>
  <li>If column <code>A = Chennai</code> and column <code>D = CH</code> then move to sheet <code>CH</code>.</li>
  </ul>
  
  <p>Could you please help me to create VB script to move these data in a run to there respective sheets.</p>
  
  <p>It will be great help to me. I am spending almost 3 hours to complete this task.</p>