Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting financial data from Morningstar
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting financial data from Morningstar
How about a sample url of the page(s) you want and the info from along with
excel version. Have you tried right clickimport to microsoft excelclean up with a macro? -- Don Guillett SalesAid Software "Gallardo" wrote in message oups.com... 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting financial data from Morningstar
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
Conditional Formatting not applied to data exported from Access | Excel Worksheet Functions | |||
cell formatting problems | New Users to Excel | |||
Formatting data | Excel Discussion (Misc queries) |