Request for creating a CSV file from a? spreadsheet.
?
I require a csv file to be created from a spreadsheet.
ColA : is the customer.
ColB: is the product code and description
Col C onwards are the forecast quantities and are valid aslong as the col heading is a date. There is a total col at the end.
?
I need a csv to be in the following format.
2009,29/12/2008,,,,,,,,,,,,,,,,,
2010,4/01/2010,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,
code,,desc,22/06/2009,29/06/2009,6/07/2009,13/07/2009,20/07/2009,27/07/2009,3/08/2009,10/03/2009,17/08/2009,24/08/2009,31/08/2009,7/09/2009,14/09/2009,21/09/2009,,
129000,129000,MANGO YUM,4000,0,0,0,4000,0,0,0,4000,0,0,0,4000,,16000,
The first 3 lines are as shown and I need to be able tomodify them
The fourth line is the heading row with the dates comingfrom the spreadsheet.
The other lines are the forecasts.
They are totaled by item code for each week from thespreadsheet.
?
Any questions please feel free to ask.