How do I copy a link that is in columns to another worksheet down.
 

How do I paste a link that is in colums to another worksheet down in rows.
such as.
4/15/05 4/16/05 4/17/05
40 40 40

4/15/05 40
4/16/05 40
4/17/05 40
I tried to paste the link from one worksheet cell to another worksheet and
use the fill feature and when you do this it changes the row number not the
column letter! Some help would be very much appreciated- Thank You

Highlight the two rows, Copy, put your cursor in another cell, Edit, Paste
Special, transpose (just above the OK), OK

Carole O

"Bolynx" wrote:

How do I paste a link that is in colums to another worksheet down in rows.
such as.
4/15/05 4/16/05 4/17/05
40 40 40

4/15/05 40
4/16/05 40
4/17/05 40
I tried to paste the link from one worksheet cell to another worksheet and
use the fill feature and when you do this it changes the row number not the
column letter! Some help would be very much appreciated- Thank You