View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
The Tan Man The Tan Man is offline
external usenet poster
 
Posts: 2
Default 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