Auto Fill formula from a column to row

M

Margy

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.
 
S

Sheeloo

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()))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy paste data from a column to a row 0
How to transpose data (Row to column) without losing the cell link 3
Auto Fill formula when inserting a new line 4
Macro to autofill from a specific row to a specific row 2
Transpose Large Column to Row 2
Need Macro to autofill formula to last row with data 4
Auto fill values with a blank row formatting between entries 7
Excel Help to copy information from one row at a time to another sheet 1

Top