Excel Automation for PO and Invoice Data

Job ID: 39404769

Budget: €12 – €18 EUR

I need a freelancer to automate the conversion of Autoquotes files into Excel and populate Excel with PO and invoice data.

Requirements:
- Convert Autoquotes Excel files and format for import:
- Remove inactive lines
- Add net cost column (calculated as unit next cost x quantity)
- Summarize to one line

Ideal skills and experience:
- Proficiency in Excel
- Experience with data manipulation and file conversion
- Attention to detail

Looking for someone who can deliver accurate and well-organized data.