View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett
 
Posts: n/a
Default Formatting financial data from Morningstar

Right click on the table on the web siteselect import to microsoft
excelafter imported, hide the undesired columnsright click on the cell A2
and select refresh.

--
Don Guillett
SalesAid Software

"Gallardo" wrote in message
oups.com...
Thanks for the quick reply!
Excel 2002.

http://quicktake.morningstar.com/Sto...ktab=financ e

Just the financial statement (1995 from upper left corner to 2406 at
bottom right)

Whenever I try c/p or use web import, it would include countless blank
rows and colums that spands several pages.

Not familiar with macros.