copying and pasting question

[gemann]

Is there a way to copy data lets say from column A1 to A* from one
spreadsheet, into lets say row 1 of another spreadsheet

 

[Dave Peterson]

If * is less than 257, you can select your range (a1:A99 say) and then

select A1 of the second worksheet and then
Edit|paste special and check that Transpose box.

(256 columns is the max in excel.)

 

[gemann]

great i'll give it a try

If * is less than 257, you can select your range (a1:A99 say) and then

select A1 of the second worksheet and then
Edit|paste special and check that Transpose box.

(256 columns is the max in excel.)