software

Does anyone have code/macro to format data copy/pasted from
Morningstar? There is a lot of excess colums/rows that make it very
hard to read/work with. Thanks.How about a sample url of the page(s) you want and the info from along with
excel version. Have you tried right clickgt;import to microsoft excelgt;clean up
with a macro?

--
Don Guillett
SalesAid Software

quot;Gallardoquot; gt; wrote in message oups.com...
gt; Does anyone have code/macro to format data copy/pasted from
gt; Morningstar? There is a lot of excess colums/rows that make it very
gt; hard to read/work with. Thanks.
gt;
Thanks for the quick reply!
Excel 2002.

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.Right click on the table on the web sitegt;select import to microsoft
excelgt;after imported, hide the undesired columnsgt;right click on the cell A2
and select refresh.

--
Don Guillett
SalesAid Software

quot;Gallardoquot; gt; wrote in message oups.com...
gt; Thanks for the quick reply!
gt; Excel 2002.
gt;
gt; quicktake.morningstar.com/Sto...ktab=financ e
gt;
gt; Just the financial statement (1995 from upper left corner to 2406 at
gt; bottom right)
gt;
gt; Whenever I try c/p or use web import, it would include countless blank
gt; rows and colums that spands several pages.
gt;
gt; Not familiar with macros.
gt;