Copying data different sheet

[Amanolkar]

Hi

i want to copy data from a column to a row in different sheet but sam
workbook.
i have attached the workbook below.
i want to get data from "K" column of "QA Form" into "Data" sheet ro
wise, & also the textbox data into "DATA" sheets colum headde
column..
how is that possible..
pls help me its urgent.

+-------------------------------------------------------------------
|Filename: New Online Quality.zip
|Download: http://www.excelforum.com/attachment.php?postid=4895
+-------------------------------------------------------------------

 

[mrice]

You can get the question answers across by selecting Cells K8 to K109,
switching to the data sheet, selecting cell a2. Then Edit - paste
special-transpose.

The text box data can be added by selecting the text inside the box and
then copy/paste.

Try automating this by recording a macro.

 

[Roelof van Wyk]

I cannot link to the sheet, have you tried Paste special> Transpose?. Unless
I understand you incorrectly, you want data in a column copied to a row.
Paste the Values as well if it relates to formulas.