PASTE LINK FROM HORIZONTAL CELLS TO VERTICAL CELLS
 

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

PASTE LINK FROM HORIZONTAL CELLS TO VERTICAL CELLS
 

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

PASTE LINK FROM HORIZONTAL CELLS TO VERTICAL CELLS
 

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