title: How to create a reference between a column and a row of another sheet and vice versa - Excel VBA?
body: <p>I have asked and provided my own answer, although it is not good but it works. 
  <a href="https://stackoverflow.com/questions/10467639/transform-single-row-to-single-column-with-reference-excel-vba">Previous Question</a></p>
  
  <p>However, now I would like to link cells from another sheet. However, the program I wrote could not make reference among cells from one sheet to another sheet.</p>
  
  <p><strong>Example</strong></p>
  
  <p>Sheet1, Column A</p>
  
  <p>Sheet2, row 1</p>
  
  <p>I want to have</p>
  
  <pre><code>Sheet1!A1 = Sheet2!A1
  Sheet1!A2 = Sheet2!B2
  </code></pre>
  
  <p><img src="https://i.stack.imgur.com/1i3mm.jpg" alt="enter image description here"></p>