I have a program that outputs an excel data XLS file. I want to have a standard, formatted and well-designed template that can read this raw data from a secondary tab and then "re-format" it for display and printing needs. The raw data comes in all as "text" even though it is numeric data, so it will need a simple VBA program to "scrub" the data to numeric first. Then some conditional excel formatting on the first tab to read and format the data from the second tab. Pretty easy stuff... I have detailed instructions and a sample file ready in an Excel doc - PM me for details... Thanks
do you still need help? let me now the detail of your excel formatting request.. may be i can do it..