G Guest Nov 23, 2004 #1 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
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
D Dave Peterson Nov 23, 2004 #2 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.)
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.)
G Guest Nov 23, 2004 #3 great i'll give it a try Dave Peterson said: 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.) Click to expand...
great i'll give it a try Dave Peterson said: 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.) Click to expand...
