Excel Macro
Budget: $10 – $30 USD
I need to convert a CSV file into a XLS file with aesthetic changes such as grid lines
I have put the CSV file that I get from my system and the dollied up version as well.
Some challenges, these reports are client specific they will always have the same columns, but the number of rows for each job number may change and also line items be different. I think tho that one can send the software to the heading, box what is beneath, and then see the next heading bold it and box what is beneath. There is a key where we want certain things coloured if they change their status.
The file needs to be opened, saved as an XLS document and the macro run or vice versa, but what would also be good is if the xls sheet once modified can be locked and nothing can be done to change it. (people can change dates for delivery which would be bad for us)
I have put the CSV file that I get from my system and the dollied up version as well.
Some challenges, these reports are client specific they will always have the same columns, but the number of rows for each job number may change and also line items be different. I think tho that one can send the software to the heading, box what is beneath, and then see the next heading bold it and box what is beneath. There is a key where we want certain things coloured if they change their status.
The file needs to be opened, saved as an XLS document and the macro run or vice versa, but what would also be good is if the xls sheet once modified can be locked and nothing can be done to change it. (people can change dates for delivery which would be bad for us)