Creating a table from Excel data
 

I have a substantial excel spreadsheet with 10 columns of simple
text/figures, and I need to frequently lift the data from a single row
and display it seperately in the form of a simple vertical 10-row x 1
column table that can be dropped into other documents such as a web
page. What is the easiest way to process this task, and can it be
condensed into a macro that is readily available for future use?
All suggestions will be welcome, or pointers to other helpful
information.


--
Richard Dean
------------------------------------------------------------------------
Richard Dean's Profile: http://www.excelforum.com/member.php...o&userid=32102
View this thread: http://www.excelforum.com/showthread...hreadid=518610

Creating a table from Excel data
 

use copy-pastespcial-transpose
yes suggest you record a macro doing these steps and genealise the macro by
modifying.


"Richard Dean"
wrote in message
...

I have a substantial excel spreadsheet with 10 columns of simple
text/figures, and I need to frequently lift the data from a single row
and display it seperately in the form of a simple vertical 10-row x 1
column table that can be dropped into other documents such as a web
page. What is the easiest way to process this task, and can it be
condensed into a macro that is readily available for future use?
All suggestions will be welcome, or pointers to other helpful
information.


--
Richard Dean
------------------------------------------------------------------------
Richard Dean's Profile:
http://www.excelforum.com/member.php...o&userid=32102
View this thread: http://www.excelforum.com/showthread...hreadid=518610