Hi!

I have 2 sheets. On one sheet I have a vertical column with numbers from 1-36. I would like to reference these numbers in a second sheet however to a horizontal row. WHen I am referencing :
first =Calculations!F12
second: =Calculations!F13
third= =Calculations!F14

I have a lot of numbers, how can I copy the formula so it will automatically reference to sheet 1? I tried fixing with $F12 however then the F column is good because it is not moving however the 12-13-14 is not growing but stays the same: f12-f12-f12-f12