Project Description:
I need application stand alone to transform file CSV to Excel 97/2000 .xls
The CVS contain all customers information 37 colums I want in Excel just 12 principal colums + 1 more colum with code of product made by application stand alone taking code from 1 more CVS.
In Excel ordered A->Z the product, but Same name have to stay togheter and not follow ordered product, all Same name in yellow background, quantity more than 1 in red background white written, shipping metod different of priority red background white written.
I need Total of different names, total Euro amount, total of transactions.
In Excel page 2 order information for print 24 label 70x37 cm no margins.
I have 1 excel macro do half job.
Thanks
Additional Project Description:
02/05/2013 at 1:43 WIT
In Excel page 2 creating 24 labels 70x37cm each page with address information for print.
Save 2 file xls:
1) File excel append containing all week
2) file excel insert for each day