we are looking for an expert with VBA formulas, possibly with some basic accounting experience. The winner of this job has possible a lot more jobs succeeding to this one, depending on the skill, full time employment is possible in the future.
We are looking for candidates with proven track record here and feedback above 4,9
we have a fix job of transforming a CSV file that comes out of our webpage, from one format, to the format that our logistic center needs.
The job has about 7 steps,outlined bellow, but the detailed file will be sent before the final job offer is awarded so the contractor can revise the bid.
The file to transform will consist of a file with severall line and columns, with the details of our orders.
the transformation steps would be
1. Cleaning lines that do not contain any orders
2. Cleaning and substituting caracters that have been transformed due to the system not accepting certain caracters
3. removal of #sign on column A
4. re-order and re-naming of columns, some coluns will be deleted, others added
5. orders have multiple lines, but address shows only on the first line of each order. Transform so that all lines of the same order have same address data
6. Orders that have comments, should be marked in red
7. Bellow each order number, there should be a line called "gastos" with a fix value of 7 euros
8. The file should use semicolon and not colon separation, it should be save in csv formatting.
Other open jobs by this client
- Fixed-Price – Accounting Expert invoicing automation