Need a formula to link colum cells to row cell in a different sheet
 

I need to enter formla in a column (50 cells) that is linked a row
(also 50 cells) in a different sheet but same workbook. Is there a
quick way to do this? Note: I tried to do Paste Special and used
Transpose, but Paste Link greys out when I do this and I only end up
with values in the column cells instead of formulas. Any ideas how to
do this?

Tan Man