Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 56
Default Transferring data to excel spreadsheet 2003

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 9,101
Default Transferring data to excel spreadsheet 2003

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
transferring data from quattro pro to excel from cd-rw 1lkywmn Excel Discussion (Misc queries) 0 December 5th 06 08:17 PM
Transferring data from MS Access to MS Excel Joe Excel Discussion (Misc queries) 2 April 5th 06 06:24 PM
Transferring Data Susan Excel Worksheet Functions 0 January 25th 06 08:57 PM
Transferring Excel Data to Word Document maacmaac Excel Discussion (Misc queries) 0 October 6th 05 05:23 PM
formulas for transferring data validation information in excel 200 Tony Excel Worksheet Functions 1 November 9th 04 10:21 PM


All times are GMT +1. The time now is 09:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"