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