Daniel, this is an urgent Excel refinement to the FT program. Could you do it on the fly ? If not, I must ask somebody else.
---------------------------------Description---------------------
This Excel utility aims at preparing for easier further calculations te output files of Formula 3 A
-------------------------------------------------------------------
0) the utility will open all F3A files and save them each as Excel file (Excel 2003 workbook xls) with their same name
1) select the whole worksheet and set font "calibri 10"
2) select first row at the top and center content (these will be the headers of the columns)
3) set headers'font to bold , "black color", "light yellow" background
4) place headers'row in an horizontal pane and freeze it, so that the headers remain fixed when the window is scrolled
5) select all worksheet's columns and autofit their width
6) select "ClosingDate column" and set format of its content to "[login to view URL]"
7) select all columns right to ClosingDate (from "Price" to "EV/Ebit" column) and align their content to the right, then set their numerical
format to "two decimals" and with "red" as color of the negative numbers: #,##0,00_);[Red](#,##0,00) --- be careful keeping alignment of headers
to center, not to the right !
8) eliminate gridlines'view
10) select the whole content of the worksheet and sort by "ClosingDate" ascending
11) select columns from P/S to EV/Ebit and highlight their background in "light turquoise"
12) create as many copies of the worksheet of (the worksheet not the workbook !), as there are years
in the content of ClosingDate column: 2004, 2005, 2006, 2007, etc.. Each single worksheet shall be named after the year !!
13) delete from each single year-worksheet all rows of data that refer to a different year than the name of the worksheet.
As an example, the 2004-worksheet shall contain only 2004 data
14) select the content of each year-worksheet and sort by "Market Capitalisation", ascending
15) out of each year-worksheet generate two worksheets: the first will contain only the rows of data that have a Market Capitalisation equal
or lower than 500.000.000. The second will contain only the rows of data that have a Market Capitalisation higher than 500.000.000,00. You will label
the resulting worksheets this way: "YYYY 500M-" and "YYYY 500M+" (examples: "2005 500M- " "2009 500M+")
save and close all files
-----------------------------------------------------------
I attach a sample. Please reply soon
Ciao
Ascanio