How do I link horizontal cells vertically?
 

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

How do I link horizontal cells vertically?
 

Something like:

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

HTH
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=497720

How do I link horizontal cells vertically?
 

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!
==============================================




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

How do I link horizontal cells vertically?
 

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.

"Brett" wrote:

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