Copy this to A3 then drag/copy down column A.

=INDEX($5:$5,ROWS($2:5))


Gord Dibben MS Excel MVP


=I have several columns of data

I am trying to put a formula in A3 that will read say, =D5
When i drag this down on autofill it then reads =D6 (in cell A4), =D7(in
cell A5), =D8 (in cell A6) etc
Is it possible on autofill to get it to read =E5, =F5, =G5, =H5, =I5 etc as
i drag the formula down?

Thanks in advance!

Richard