Auto Fill formula from a column to row
 

Need to autofill cells in a column which is linked to a row (i.e. =C74) that
has formulas. Figures need to be transposed from the column to a row but
still be linked to the source row. Tried paste special with transpose &
formulas selected - but going from verticle to horizontal the result comes
back 0. Any suggestions please.

Working in Excel 2007.
--
With thanks
Margy
Pinetown, South Africa

Auto Fill formula from a column to row
 

If you want values in row 74 from Col C onwards in Col A starting at Row 75
then enter this in A75 and copy down;
=INDIRECT("R74C"&(ROW()-72),FALSE)

If you want to start at A1 then enter this in A1
=INDIRECT("R74C"&(ROW()+2),FALSE)

Basically whereevery you start ROW()+n should give you 74..

To transpose Col to Row use a formula like
=INDIRECT("A"&(COLUMN()))
--
Always provide your feedback so that others know whether the solution worked
or problem still persists ...


"Margy" wrote:

Need to autofill cells in a column which is linked to a row (i.e. =C74) that
has formulas. Figures need to be transposed from the column to a row but
still be linked to the source row. Tried paste special with transpose &
formulas selected - but going from verticle to horizontal the result comes
back 0. Any suggestions please.

Working in Excel 2007.
--
With thanks
Margy
Pinetown, South Africa