title: How to map two columns
body: <p>I have Five columns.    </p>
  
  <p><strong>E.g.</strong> </p>
  
  <ol>
  <li>Column1: Name </li>
  <li>Column2: surname </li>
  <li>Column3: mapping  </li>
  <li>Column4: Mapped data</li>
  </ol>
  
  <p>Columns contain data like </p>
  
  <pre><code>      Name         Surname        Mapping    Name1   Surname1
    1   ABC          1  AAAA          3         ABC      QQQQ
    2   XYZ          2  XXXX          1         XYZ      AAAA
    3   OPQ          3  QQQQ          4         OPQ      QQQQ
    4   RST          4  RRRR          2         RST      RRRR
  </code></pre>
  
  <p>Now my aim is to map name column to surname by using mapping column and result should be stored at Name1 and Surname1 column. I have more data in Name and Surname column, by writing number in Mapping column it will automatically map the surname to Name (the choice is given to user for entering number in mapped column then map the data accordingly) and result should be copied in Name1 and Surname1.</p>
  
  <p>I am not getting any idea to achieve this using VBA. coding Plz help me.....</p>