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?

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" <Brett@discussions.microsoft.com> wrote in message
news:DBC18A9B-DC9D-4530-862E-79CAA0916D7E@microsoft.com...
> I'd like to copy a link vertically, but the cells to link to are
horizontal.
> How do I do this?

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?