How do I link horizontal cells vertically?

[Guest]

I'd like to copy a link vertically, but the cells to link to are horizontal.
How do I do this?

 

[pinmaster]

Something like:

=INDIRECT("A"&COLUMN(A1))
copied across

HTH
JG

 

[RagDyer]

Since you said "copy a link", you *can't* use "Paste Special" & "Transpose".

So, try this:

Original data in A1 to Z1,

Enter this anywhere, and copy down 26 rows:

=INDEX($A$1:$Z$1,ROWS($1:1))

OR, if the data is more extensive, you can index an entire row, and copy
down as far as needed:

=INDEX($1:$1,ROWS($1:1))
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

 

[Guest]

Brett, I can't take credit for this because I read it here once before, but
you can create the formulas you want horizontally, then highlight the row of
formulas and
Edit, Replace
Find What: =
Replace With: Brett= 'or some other odd string
Replace All
Edit, Copy, go to the cell where you want to put the column of formulas
Edit, Paste Special, Transpose, OK
Edit, Replace
Find What: Brett=
Replace With: =
Replace All

It looks complicated, and I haven't yet figured out the best way to show
menu command selections, but it's really not that hard to do.