Maybe you started with a bad example.
You can only go down Column E for 4 cells since you'll then run into the
contents of E1, where you started from ... right ? ? ?
So, guessing that you want to drag a formula *down* a column and reference
the contents of a row, let's try this scenario:
A1 to AX1 contains the numbers 10 to 500.
To copy those values down Column E, starting at E2,
enter this formula in E2 and drag down to copy as needed:
=INDEX($1:$1,ROW(1:1))
If the values were in A5 to AX5,
then starting in E6 you would use:
=INDEX($5:$5,ROW(1:1))
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
"oberon.black"
wrote in message
news:oberon.black.1xh22j_1130267135.1302@excelforu m-nospam.com...
I have a excel xls that I will create into a very large project. the
setup is as follows for my test.
a1 = 1
b1 = 2
c1 = 3
d1 = 4
I then want:
e1 = a1
so i put =a1 in cell e1, however I want e2 to = b1, and e3 to = c1 and
so on.
I do not want to manually insert =(cell) in each cell that I want to
transpose to. So what kind of formula could I use to complete this
task. I would like to drag formula down the e column.
Please help. I have no idea on how to write such a formula please
construct.
Thanks
--
oberon.black
------------------------------------------------------------------------
oberon.black's Profile:
http://www.excelforum.com/member.php...o&userid=26732
View this thread: http://www.excelforum.com/showthread...hreadid=479217