dynamically link column to row in different sheet

F

FSRleader

Hi all,

I have two worksheets.
In sheet1 I have a row at the bottom that totals up everything in th
individual columns. This row extends from C21 to Q21.

In sheet2 I am trying to take the data from C21 to Q21 in the origina
sheet and transpose it vertically into C55 to C69, all the while makin
sure it is dynamically linked to the data in sheet1.

I know its only 15 cols/rows, but for future reference I want to kno
how to do this effectively. Any help would be appreciated
 
F

Frank Kabel

Hi
enter the following formula in C55
=OFFSET('sheet1'!$C$21,0,ROW(1:1)-1)
and copy this formula down to cell C69
 
Top