Hi

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


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

--
Amanolkar
------------------------------------------------------------------------
Amanolkar's Profile: http://www.excelforum.com/member.php...o&userid=35475
View this thread: http://www.excelforum.com/showthread...hreadid=552523

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.


--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=552523

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.