I am not very experienced at Excel (2007) , but I have this problem I would like to handle in an automated way, and am pretty sure it can be done, but I don't know how. Would appreciate some advice.
I want to start with a fairly simple CSV file, open it into an already created excel template that has some header rows before the actual data rows, and some simple formatting like colored cell fills, borders, and, the only 'tricky' part, a few of the columns need to do a macro involving subtracting one date from another, and then display one of 4 colored 'balls' (red, yellow, green, black), instead of the date.
The CSV data looks like this:
ABC,Axxx Cxxxx,,,,,30-Jun-2007,,,,30-Jun-2009,Xyz abc
The several empty fields are were the colored balls will go, based on cals from the date fields.
The formatted fields look like this:
Finally, the whole thing is outputted as a PDF.
Thanks for any help you can provide.
John Spaulding
I want to start with a fairly simple CSV file, open it into an already created excel template that has some header rows before the actual data rows, and some simple formatting like colored cell fills, borders, and, the only 'tricky' part, a few of the columns need to do a macro involving subtracting one date from another, and then display one of 4 colored 'balls' (red, yellow, green, black), instead of the date.
The CSV data looks like this:
ABC,Axxx Cxxxx,,,,,30-Jun-2007,,,,30-Jun-2009,Xyz abc
The several empty fields are were the colored balls will go, based on cals from the date fields.
The formatted fields look like this:
Finally, the whole thing is outputted as a PDF.
Thanks for any help you can provide.
John Spaulding