| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can i tell excel the data it has is in essence a pivot table | Excel Discussion (Misc queries) | |||
| Deleting data in a table from excel export | Excel Discussion (Misc queries) | |||
| Show text data in excel pivot table | Excel Discussion (Misc queries) | |||
| AHHHH-Get Data from Multiple Excel workbooks | Excel Discussion (Misc queries) | |||
| data transfer from Excel to Access but the new table stru is diff | Excel Discussion (Misc queries) | |||
Linear Mode
