title: How to autofill vertically and change column instead of row?
body: <p>I currently have a formula in another worksheet where I refer to a specific variable cell:</p>
  
  <pre><code>=Units!B3
  </code></pre>
  
  <p>When I drag using autofill, it fills and changes the row e.g B4,B5,B6. However, I want to drag it down and make it change to C3,D3,E3,F3,G3, etc</p>
  
  <p>How could I do this? I am aware of transpose, but didn't give me any luck.</p>
  
  <p>Cheers</p>