I need to paste link fron horizontal cells to vertical cells. tks

Dave Peterson answered this question before. See his answer at:

http://www.microsoft.com/office/comm...ea2&sloc=en-us

"Luis P." wrote:

I need to paste link fron horizontal cells to vertical cells. tks

Original data on Sheet1, Row1
A1 to whatever.

To link this to Sheet2,
Enter this *anywhere* on Sheet2, and copy down as needed:

=INDEX(Sheet1!$1:$1,ROWS($1:1))

--

HTH,

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




"Luis P." wrote in message
...
I need to paste link fron horizontal cells to vertical cells. tks