title: mapping column headers from one sheet to another
body: <p>i wanted to map columns from one worksheet to another and this is the code i have tried: </p>
  
  <pre><code>Dim x As Integer
  x = 2
  Do Until Sheets("Sheet1").Range("A" &amp; x).Value = ""
  Sheets("Sheet2").Range("C" &amp; x).Value = Sheets("Sheet1").Range("A" &amp; x).Value
  x = x + 1
  Loop
  x = 2
  Do Until Sheets("Sheet1").Range("B" &amp; x).Value = ""
  Sheets("Sheet2").Range("A" &amp; x).Value = Sheets("Sheet1").Range("B" &amp; x).Value
  x = x + 1
  Loop
  x = 2
  Do Until Sheets("Sheet1").Range("C" &amp; x).Value = ""
  Sheets("Sheet2").Range("B" &amp; x).Value = Sheets("Sheet1").Range("C" &amp; x).Value
  x = x + 1
  Loop
  </code></pre>
  
  <p>in worksheet1 i have:                          </p>
  
  <pre><code>  A                 B            C 
  1 applicationname applicationid number 
  2 applcation1          1          123 
  3 applcation2          2          454 
  4 applcation3          3          897
  </code></pre>
  
  <p>in worksheet2 i got: </p>
  
  <pre><code>  A                 B            C 
  1  appid           num        appname              
  2   1              123        applcation1          
  3   2              454        applcation2          
  4   3              897        applcation3 
  </code></pre>
  
  <p>the problem is there are many other columns and this code seems to be lengthy..i need to loop so that applicationid maps to appid and so on ..i want to know wether there is a way to map columns based on the headers(the data in first row) and can anyone please say what to do if i want to copy the empty cells also? 
  may i know wether i can have an worksheet like interface say sheet3 where i can fill the required mappings like   </p>
  
  <pre><code>     A                       B
   1   Application Name        App Name
   2   Application ID          AppID
   3   Technology              Tech
   4   Business Criticality    Bus Criticality
   5   IT Owner                IT Owner
   6   Business Owner    BusOwner                                                            and accordingly map them?thanks in advance
  </code></pre>