Excel Integration & Standardisation of a Excel Quote Document
Budget: $250 – $750 AUD
I need a framework to standardize and integrate multiple CSV stock lists into an Excel quoting sheet, which will then be exported/imported to MYOB for invoice generation.
Key Tasks:
- Standardize 45 stock lists (25,000 products)
- Create an Excel search function with keyword search
- Enable export/import to MYOB
- Auto-generate POs for 1-20 suppliers per invoice
Ideal Skills & Experience:
- Proficiency in Excel and MYOB
- Experience with CSV file manipulation and data standardization
- Strong attention to detail and organizational skills
Please provide a sample of similar work done, if available.
Key Tasks:
- Standardize 45 stock lists (25,000 products)
- Create an Excel search function with keyword search
- Enable export/import to MYOB
- Auto-generate POs for 1-20 suppliers per invoice
Ideal Skills & Experience:
- Proficiency in Excel and MYOB
- Experience with CSV file manipulation and data standardization
- Strong attention to detail and organizational skills
Please provide a sample of similar work done, if available.