Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I routinely visit a website for my investments. The performance information
is offered in a grid-like form [without the actual grid]. I find that I can copy a row of data but the entire rows' data finds its' way into the first column of the spreadsheet. I know that I can copy each column of information but the time would be immense. I do not know if this is a function of the webpage or the configuration of the spreadsheet. Much thanks for any guidance. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
some investing websites like Yahoo havve a feature that you can download a
CSV (commar seperatted values) file. the CSV file can be imported into Excel on the Data Menu - Import External Data Menu option select Commars as the delimiter character. "Maurice" wrote: I routinely visit a website for my investments. The performance information is offered in a grid-like form [without the actual grid]. I find that I can copy a row of data but the entire rows' data finds its' way into the first column of the spreadsheet. I know that I can copy each column of information but the time would be immense. I do not know if this is a function of the webpage or the configuration of the spreadsheet. Much thanks for any guidance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
transferring data from quattro pro to excel from cd-rw | Excel Discussion (Misc queries) | |||
Transferring data from MS Access to MS Excel | Excel Discussion (Misc queries) | |||
Transferring Data | Excel Worksheet Functions | |||
Transferring Excel Data to Word Document | Excel Discussion (Misc queries) | |||
formulas for transferring data validation information in excel 200 | Excel Worksheet Functions |